eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_IMPORT_UTIL_PVT dependencies on EGO_MTL_SY_ITEMS_EXT_B

Line 2165: EGO_MTL_SY_ITEMS_EXT_B ext_prod,

2161: l_ag_sql := q'#
2162: SELECT
2163: ext_prod.ATTR_GROUP_ID
2164: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
2165: EGO_MTL_SY_ITEMS_EXT_B ext_prod,
2166: MTL_PARAMETERS mp
2167: WHERE msii.STYLE_ITEM_FLAG = 'N'
2168: AND msii.SET_PROCESS_ID = #' || p_batch_id || q'#
2169: AND msii.TRANSACTION_TYPE = 'CREATE'

Line 2275: EGO_MTL_SY_ITEMS_EXT_B ext_prod,

2271: l_ag_sql := q'#
2272: SELECT
2273: ext_prod.ATTR_GROUP_ID
2274: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
2275: EGO_MTL_SY_ITEMS_EXT_B ext_prod,
2276: MTL_PARAMETERS mp
2277: WHERE msii.STYLE_ITEM_FLAG = 'N'
2278: AND msii.SET_PROCESS_ID = #' || p_batch_id || q'#
2279: AND msii.TRANSACTION_TYPE = 'CREATE'

Line 2382: EGO_MTL_SY_ITEMS_EXT_B ext_prod

2378: l_ag_sql := q'#
2379: SELECT
2380: ext_prod.ATTR_GROUP_ID
2381: FROM MTL_ITEM_REVISIONS_INTERFACE miri,
2382: EGO_MTL_SY_ITEMS_EXT_B ext_prod
2383: WHERE miri.SET_PROCESS_ID = #' || p_batch_id || q'#
2384: AND miri.TRANSACTION_TYPE = 'CREATE'
2385: AND miri.PROCESS_FLAG = 1
2386: AND miri.INVENTORY_ITEM_ID = ext_prod.INVENTORY_ITEM_ID

Line 2491: EGO_MTL_SY_ITEMS_EXT_B ext_prod,

2487: SELECT
2488: ext_prod.ATTR_GROUP_ID
2489: FROM
2490: MTL_SYSTEM_ITEMS_INTERFACE msii,
2491: EGO_MTL_SY_ITEMS_EXT_B ext_prod,
2492: MTL_PARAMETERS mp
2493: WHERE msii.SET_PROCESS_ID = #' || p_batch_id || q'#
2494: AND msii.PROCESS_FLAG = 1
2495: AND msii.TRANSACTION_TYPE = 'CREATE'

Line 2645: EGO_MTL_SY_ITEMS_EXT_B ext_prod

2641: SELECT
2642: ext_prod.ATTR_GROUP_ID
2643: FROM
2644: EGO_ITEM_ASSOCIATIONS_INTF eiai,
2645: EGO_MTL_SY_ITEMS_EXT_B ext_prod
2646: WHERE eiai.BATCH_ID = #' || p_batch_id || q'#
2647: AND eiai.TRANSACTION_TYPE = 'CREATE'
2648: AND eiai.DATA_LEVEL_ID = #' || l_item_sup_dl_id || q'#
2649: AND eiai.PROCESS_FLAG = 1

Line 2763: EGO_MTL_SY_ITEMS_EXT_B ext_prod

2759: SELECT
2760: ext_prod.ATTR_GROUP_ID
2761: FROM
2762: EGO_ITEM_ASSOCIATIONS_INTF eiai,
2763: EGO_MTL_SY_ITEMS_EXT_B ext_prod
2764: WHERE eiai.BATCH_ID = #' || p_batch_id || q'#
2765: AND eiai.TRANSACTION_TYPE = 'CREATE'
2766: AND eiai.DATA_LEVEL_ID = #' || l_item_sup_site_dl_id || q'#
2767: AND eiai.PROCESS_FLAG = 1

Line 2890: EGO_MTL_SY_ITEMS_EXT_B ext_prod,

2886: SELECT
2887: ext_prod.ATTR_GROUP_ID
2888: FROM
2889: EGO_ITEM_ASSOCIATIONS_INTF eiai,
2890: EGO_MTL_SY_ITEMS_EXT_B ext_prod,
2891: MTL_PARAMETERS mp
2892: WHERE eiai.BATCH_ID = #' || p_batch_id || q'#
2893: AND eiai.TRANSACTION_TYPE = 'CREATE'
2894: AND eiai.DATA_LEVEL_ID = #' || l_item_sup_site_org_dl_id || q'#

Line 6198: FROM EGO_MTL_SY_ITEMS_EXT_B ext

6194: AND assoc.CLASSIFICATION_CODE = TO_CHAR(msii.ITEM_CATALOG_GROUP_ID)
6195: AND assoc.OBJECT_ID = l_item_object_id
6196: AND assoc.DATA_LEVEL_ID = l_item_dl_id
6197: AND NOT EXISTS (SELECT NULL
6198: FROM EGO_MTL_SY_ITEMS_EXT_B ext
6199: WHERE ext.ORGANIZATION_ID = esvas.ORGANIZATION_ID
6200: AND ext.INVENTORY_ITEM_ID = esvas.SKU_ITEM_ID
6201: AND ext.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
6202: AND ext.DATA_LEVEL_ID = assoc.DATA_LEVEL_ID