View: EGO_GTIN_TP_ATTRS_V

Product:	EGO - Advanced Product Catalog
Description:	View for Trading partner specific gtin attributes
Implementation/DBA Data:	APPS.EGO_GTIN_TP_ATTRS_V

View Text

SELECT UE.INVENTORY_ITEM_ID
, UE.ORGANIZATION_ID
, UE.GTIN
, UE.TP_GLN
, DECODE(MSI.CUSTOMER_ORDER_ENABLED_FLAG
, 'Y'
, 1
, 'N'
, 0
, 0) IS_TRADE_ITEM_AN_ORD_UNIT
, SYSDATE
, NVL(ECI.END_AVAILABILITY_DATE_TIME
, EGA.END_AVAILABILITY_DATE_TIME) END_AVAILABILITY_DATE_TIME
, NVL(ECI.START_AVAILABILITY_DATE_TIME
, EGA.START_AVAILABILITY_DATE_TIME) START_AVAILABILITY_DATE_TIME
, DECODE(NVL(ECI.IS_TRADE_ITEM_A_DESPATCH_UNIT
, MSI.SHIPPABLE_ITEM_FLAG)
, 'Y'
, 1
, 'N'
, 0
, 0) IS_TRADE_ITEM_A_DESPATCH_UNIT
, DECODE(NVL(ECI.IS_TRADE_ITEM_AN_INVOICE_UNIT
, MSI.INVOICE_ENABLED_FLAG)
, 'Y'
, 1
, 'N'
, 0
, 0) IS_TRADE_ITEM_AN_INVOICE_UNIT
, NVL(ECI.MIN_TRADE_ITEM_LIFE_ARR
, MSI.SHELF_LIFE_DAYS) MIN_TRADE_ITEM_LIFE_ARR
, NVL(ECI.ORDER_QUANTITY_MAX
, EGA.ORDER_QUANTITY_MAX) ORDER_QUANTITY_MAX
, NVL(ECI.ORDER_QUANTITY_MIN
, EGA.ORDER_QUANTITY_MIN) ORDER_QUANTITY_MIN
, UE.BATCH_ID
, UE.SUBBATCH_ID
FROM EGO_UCCNET_EVENTS UE
, MTL_SYSTEM_ITEMS_B MSI
, EGO_ITEM_GTN_ATTRS_B EGA
, EGO_ITEM_CUST_ATTRS_B ECI
WHERE UE.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND UE.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND UE.INVENTORY_ITEM_ID = EGA.INVENTORY_ITEM_ID
AND UE.ORGANIZATION_ID = EGA.ORGANIZATION_ID
AND UE.EVENT_TYPE = 'PUBLICATION'
AND UE.INVENTORY_ITEM_ID = ECI.INVENTORY_ITEM_ID(+)
AND UE.ORGANIZATION_ID = ECI.MASTER_ORGANIZATION_ID (+)
AND UE.PARTY_SITE_ID = ECI.PARTY_SITE_ID(+)

Columns