APPS.EGO_GTIN_PVT dependencies on EGO_ITEM_TP_ATTRS_EXT_TL

Line 550: EGO_ITEM_TP_ATTRS_EXT_TL tl,

546: ELSE Nvl( (Max(b.LAST_UPDATE_DATE)), (To_Date('01-01-1990','MM-DD-YYYY')) )
547: END
548: ) AS LAST_UPDATE_DATE
549: FROM EGO_ITEM_TP_ATTRS_EXT_B b,
550: EGO_ITEM_TP_ATTRS_EXT_TL tl,
551: EGO_UCCNET_EVENTS EV2,
552: HZ_CUST_ACCT_SITES_ALL HCAS
553: WHERE EV2.BATCH_ID = UE.BATCH_ID
554: AND EV2.TOP_ITEM_ID = UE.INVENTORY_ITEM_ID

Line 699: EGO_ITEM_TP_ATTRS_EXT_TL tl,

695: ELSE Nvl( (Max(b.LAST_UPDATE_DATE)), (To_Date('01-01-1990','MM-DD-YYYY')) )
696: END
697: ) AS LAST_UPDATE_DATE
698: FROM EGO_ITEM_TP_ATTRS_EXT_B b,
699: EGO_ITEM_TP_ATTRS_EXT_TL tl,
700: EGO_UCCNET_EVENTS EV2,
701: HZ_CUST_ACCT_SITES_ALL HCAS
702: WHERE EV2.BATCH_ID = UE.BATCH_ID
703: AND EV2.TOP_ITEM_ID = UE.INVENTORY_ITEM_ID

Line 1688: INSERT INTO EGO_ITEM_TP_ATTRS_EXT_TL

1684: FND_GLOBAL.USER_ID,
1685: SYSDATE
1686: );
1687:
1688: INSERT INTO EGO_ITEM_TP_ATTRS_EXT_TL
1689: (
1690: EXTENSION_ID,
1691: INVENTORY_ITEM_ID,
1692: MASTER_ORGANIZATION_ID,

Line 1718: FROM EGO_ITEM_TP_ATTRS_EXT_TL T

1714: FROM FND_LANGUAGES L
1715: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1716: AND NOT EXISTS
1717: (SELECT NULL
1718: FROM EGO_ITEM_TP_ATTRS_EXT_TL T
1719: WHERE T.EXTENSION_ID = l_ext_seq_val
1720: AND T.LANGUAGE = L.LANGUAGE_CODE);
1721: END;
1722: END LOOP; --FOR i IN c_customers(l_gtin) LOOP