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 2339: EGO_MTL_SY_ITEMS_EXT_B ext_prod,

2335: l_ag_sql := q'#
2336: SELECT
2337: ext_prod.ATTR_GROUP_ID
2338: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
2339: EGO_MTL_SY_ITEMS_EXT_B ext_prod,
2340: MTL_PARAMETERS mp
2341: WHERE msii.STYLE_ITEM_FLAG = 'N'
2342: AND msii.SET_PROCESS_ID = #' || p_batch_id || q'#
2343: AND msii.TRANSACTION_TYPE = 'CREATE'

Line 2452: EGO_MTL_SY_ITEMS_EXT_B ext_prod,

2448: l_ag_sql := q'#
2449: SELECT
2450: ext_prod.ATTR_GROUP_ID
2451: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
2452: EGO_MTL_SY_ITEMS_EXT_B ext_prod,
2453: MTL_PARAMETERS mp
2454: WHERE msii.STYLE_ITEM_FLAG = 'N'
2455: AND msii.SET_PROCESS_ID = #' || p_batch_id || q'#
2456: AND msii.TRANSACTION_TYPE = 'CREATE'

Line 2569: EGO_MTL_SY_ITEMS_EXT_B ext_prod

2565: l_ag_sql := q'#
2566: SELECT
2567: ext_prod.ATTR_GROUP_ID
2568: FROM MTL_ITEM_REVISIONS_INTERFACE miri,
2569: EGO_MTL_SY_ITEMS_EXT_B ext_prod
2570: WHERE miri.SET_PROCESS_ID = #' || p_batch_id || q'#
2571: AND miri.TRANSACTION_TYPE = 'CREATE'
2572: AND miri.PROCESS_FLAG = #' || p_msii_miri_process_flag || q'#
2573: AND miri.INVENTORY_ITEM_ID = ext_prod.INVENTORY_ITEM_ID

Line 2680: EGO_MTL_SY_ITEMS_EXT_B ext_prod,

2676: SELECT
2677: ext_prod.ATTR_GROUP_ID
2678: FROM
2679: MTL_SYSTEM_ITEMS_INTERFACE msii,
2680: EGO_MTL_SY_ITEMS_EXT_B ext_prod,
2681: MTL_PARAMETERS mp
2682: WHERE msii.SET_PROCESS_ID = #' || p_batch_id || q'#
2683: AND msii.PROCESS_FLAG = #' || p_msii_miri_process_flag || q'#
2684: AND msii.TRANSACTION_TYPE = 'CREATE'

Line 2834: EGO_MTL_SY_ITEMS_EXT_B ext_prod

2830: SELECT
2831: ext_prod.ATTR_GROUP_ID
2832: FROM
2833: EGO_ITEM_ASSOCIATIONS_INTF eiai,
2834: EGO_MTL_SY_ITEMS_EXT_B ext_prod
2835: WHERE eiai.BATCH_ID = #' || p_batch_id || q'#
2836: AND eiai.TRANSACTION_TYPE = 'CREATE'
2837: AND eiai.DATA_LEVEL_ID = #' || l_item_sup_dl_id || q'#
2838: AND eiai.PROCESS_FLAG = 1

Line 2952: EGO_MTL_SY_ITEMS_EXT_B ext_prod

2948: SELECT
2949: ext_prod.ATTR_GROUP_ID
2950: FROM
2951: EGO_ITEM_ASSOCIATIONS_INTF eiai,
2952: EGO_MTL_SY_ITEMS_EXT_B ext_prod
2953: WHERE eiai.BATCH_ID = #' || p_batch_id || q'#
2954: AND eiai.TRANSACTION_TYPE = 'CREATE'
2955: AND eiai.DATA_LEVEL_ID = #' || l_item_sup_site_dl_id || q'#
2956: AND eiai.PROCESS_FLAG = 1

Line 3079: EGO_MTL_SY_ITEMS_EXT_B ext_prod,

3075: SELECT
3076: ext_prod.ATTR_GROUP_ID
3077: FROM
3078: EGO_ITEM_ASSOCIATIONS_INTF eiai,
3079: EGO_MTL_SY_ITEMS_EXT_B ext_prod,
3080: MTL_PARAMETERS mp
3081: WHERE eiai.BATCH_ID = #' || p_batch_id || q'#
3082: AND eiai.TRANSACTION_TYPE = 'CREATE'
3083: AND eiai.DATA_LEVEL_ID = #' || l_item_sup_site_org_dl_id || q'#

Line 6983: FROM EGO_MTL_SY_ITEMS_EXT_B ext

6979: AND assoc.CLASSIFICATION_CODE = TO_CHAR(msii.ITEM_CATALOG_GROUP_ID)
6980: AND assoc.OBJECT_ID = l_item_object_id
6981: AND assoc.DATA_LEVEL_ID = l_item_dl_id
6982: AND NOT EXISTS (SELECT NULL
6983: FROM EGO_MTL_SY_ITEMS_EXT_B ext
6984: WHERE ext.ORGANIZATION_ID = msii.ORGANIZATION_ID
6985: AND ext.INVENTORY_ITEM_ID = msii.INVENTORY_ITEM_ID
6986: AND ext.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
6987: AND ext.DATA_LEVEL_ID = assoc.DATA_LEVEL_ID