We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Report for all items name + item code + barcode number

Received Response
23
Views
1
Comments
edited Jul 22, 2020 6:00AM in Reporting and Analytics for SCM 1 comment

Summary

Report for all items + item code + barcode number

Content

Hello All,

I need a report to display the Item Name + Item Code + Barcode Number.

I have the below table names provided by Oracle. Can someone help me with the query to display the report based on the tables please?

GTIN_ID field from table EGI_NOTIFICATION_GTINS_PK - The unique identifier (usually represented as a bar code printed on the packaging) assigned by the product brand owner or supplier.
INVENTORY_ITEM_ID field from table EGI_NOTIFICATION_GTINS_PK - Unique identifier for an item.
GTIN_DESCRIPTION field from table EGI_NOTIFICATION_GTINS_PK - Unique description associated with the GTIN.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!