DBA Data[Home] [Help]

APPS.EGO_ITEM_WS_PVT dependencies on MTL_CROSS_REFERENCES

Line 1362: MTL_CROSS_REFERENCES EgoGtinEO ,

1358: EgoGtinEO.EPC_GTIN_SERIAL AS "EpcGtinSerial"
1359: ).getclobval() ,
1360: SYSDATE
1361: FROM
1362: MTL_CROSS_REFERENCES EgoGtinEO ,
1363: MTL_SYSTEM_ITEMS_B MSIB ,
1364: MTL_PARAMETERS MP ,
1365: ( SELECT DISTINCT MCR1.CROSS_REFERENCE ,
1366: MSIK.INVENTORY_ITEM_ID ,

Line 1370: FROM MTL_CROSS_REFERENCES_B MCR1,

1366: MSIK.INVENTORY_ITEM_ID ,
1367: MSIK.CONCATENATED_SEGMENTS ITEM_NUMBER ,
1368: MSIK.ORGANIZATION_ID MASTER_ORGANIZATION_ID,
1369: MSIK.PRIMARY_UOM_CODE
1370: FROM MTL_CROSS_REFERENCES_B MCR1,
1371: MTL_SYSTEM_ITEMS_KFV MSIK ,
1372: MTL_PARAMETERS MP1
1373: WHERE MCR1.CROSS_REFERENCE_TYPE = 'GTIN'
1374: AND MCR1.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID

Line 1418: FROM MTL_CROSS_REFERENCES_TL mcrt, EGO_PUB_WS_CONFIG config, EGO_PUB_WS_FLAT_RECS flat

1414: config.char_value AS "Language" ,
1415: mcrt.DESCRIPTION AS "GTINDescription"
1416: ).getclobval() ,
1417: SYSDATE
1418: FROM MTL_CROSS_REFERENCES_TL mcrt, EGO_PUB_WS_CONFIG config, EGO_PUB_WS_FLAT_RECS flat
1419: WHERE config.SESSION_ID = flat.SESSION_ID
1420: AND config.PARAMETER_NAME = 'LANGUAGE_CODE'
1421: AND config.CHAR_VALUE = mcrt.LANGUAGE
1422: AND flat.ENTITY_TYPE = 'GTIN_CROSS_REFERENCE'