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 MTL_ITEM_REVISIONS_INTERFACE

Line 145: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI

141: l_msg_count NUMBER;
142: l_msg_data VARCHAR2(4000);
143: BEGIN
144: Debug_Conc_Log('Resolve_PKs_For_Child: Starting ');
145: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
146: SET INVENTORY_ITEM_ID = NVL((SELECT INVENTORY_ITEM_ID
147: FROM MTL_SYSTEM_ITEMS_KFV MSIK
148: WHERE MSIK.CONCATENATED_SEGMENTS = MIRI.ITEM_NUMBER
149: AND MSIK.ORGANIZATION_ID = MIRI.ORGANIZATION_ID

Line 251: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

247: AND MIRB.ORGANIZATION_ID = EIUAI.ORGANIZATION_ID
248: AND MIRB.REVISION = EIUAI.REVISION
249: ),
250: (SELECT REVISION_ID
251: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
252: WHERE MIRI.INVENTORY_ITEM_ID = EIUAI.INVENTORY_ITEM_ID
253: AND MIRI.ORGANIZATION_ID = EIUAI.ORGANIZATION_ID
254: AND MIRI.REVISION = EIUAI.REVISION
255: AND MIRI.SET_PROCESS_ID = EIUAI.DATA_SET_ID

Line 534: MTL_ITEM_REVISIONS_INTERFACE MIRI

530: MIRI.REVISION_ID, #' ||
531: l_item_rev_dl_id || q'# AS DATA_LEVEL_ID
532: FROM
533: MTL_SYSTEM_ITEMS_INTERFACE MSII,
534: MTL_ITEM_REVISIONS_INTERFACE MIRI
535: WHERE MSII.ITEM_CATALOG_GROUP_ID IS NOT NULL
536: AND MSII.SET_PROCESS_ID = #' || p_batch_id || q'#
537: AND MSII.PROCESS_FLAG = 1
538: AND MSII.SET_PROCESS_ID = MIRI.SET_PROCESS_ID

Line 633: MTL_ITEM_REVISIONS_INTERFACE MIRI,

629: NULL AS PK5_VALUE,
630: MIRI.REVISION_ID, #' ||
631: l_item_rev_dl_id || q'# AS DATA_LEVEL_ID
632: FROM
633: MTL_ITEM_REVISIONS_INTERFACE MIRI,
634: MTL_SYSTEM_ITEMS_B MSIB
635: WHERE MSIB.ITEM_CATALOG_GROUP_ID IS NOT NULL
636: AND MIRI.TEMPLATE_ID IS NOT NULL
637: AND MIRI.INVENTORY_ITEM_ID = MSIB.INVENTORY_ITEM_ID

Line 671: MTL_ITEM_REVISIONS_INTERFACE MIRI

667: END) REVISION_ID, #' ||
668: l_item_rev_dl_id || q'# AS DATA_LEVEL_ID
669: FROM
670: MTL_SYSTEM_ITEMS_INTERFACE MSII,
671: MTL_ITEM_REVISIONS_INTERFACE MIRI
672: WHERE MSII.ITEM_CATALOG_GROUP_ID IS NOT NULL
673: AND MSII.TEMPLATE_ID IS NOT NULL
674: AND MIRI.INVENTORY_ITEM_ID(+) = MSII.INVENTORY_ITEM_ID
675: AND MIRI.ORGANIZATION_ID(+) = MSII.ORGANIZATION_ID

Line 830: FROM MTL_ITEM_REVISIONS_INTERFACE miri

826: IF i.DATA_LEVEL_NAME = 'ITEM_REVISION_LEVEL' THEN
827: l_rev_where_clause := ' AND msii.COPY_REVISION_ID = ext_prod.REVISION_ID';
828: l_pk_where := ' AND ext_prod.PK1_VALUE IS NULL AND ext_prod.PK2_VALUE IS NULL ';
829: l_rev_id_sql := q'#(SELECT MAX(miri.REVISION_ID) KEEP (DENSE_RANK FIRST ORDER BY miri.REVISION)
830: FROM MTL_ITEM_REVISIONS_INTERFACE miri
831: WHERE miri.INVENTORY_ITEM_ID = msii.INVENTORY_ITEM_ID
832: AND miri.ORGANIZATION_ID = msii.ORGANIZATION_ID
833: AND miri.SET_PROCESS_ID = msii.SET_PROCESS_ID
834: AND miri.PROCESS_FLAG = 1

Line 1051: MTL_ITEM_REVISIONS_INTERFACE miri

1047: NULL AS PK5_VALUE,
1048: #' || l_item_rev_dl_id || q'# AS DATA_LEVEL_ID
1049: FROM
1050: MTL_SYSTEM_ITEMS_INTERFACE msii,
1051: MTL_ITEM_REVISIONS_INTERFACE miri
1052: WHERE miri.INVENTORY_ITEM_ID = msii.INVENTORY_ITEM_ID
1053: AND miri.ORGANIZATION_ID = msii.ORGANIZATION_ID
1054: AND msii.ITEM_CATALOG_GROUP_ID IS NOT NULL
1055: AND miri.SET_PROCESS_ID = msii.SET_PROCESS_ID

Line 2227: FROM MTL_ITEM_REVISIONS_INTERFACE miri

2223: ext_prod.ITEM_CATALOG_GROUP_ID,
2224: ext_prod.ATTR_GROUP_ID,
2225: ext_prod.DATA_LEVEL_ID,
2226: (SELECT MAX(miri.REVISION_ID) KEEP (DENSE_RANK FIRST ORDER BY miri.REVISION)
2227: FROM MTL_ITEM_REVISIONS_INTERFACE miri
2228: WHERE miri.INVENTORY_ITEM_ID = msii.INVENTORY_ITEM_ID
2229: AND miri.ORGANIZATION_ID = msii.ORGANIZATION_ID
2230: AND miri.SET_PROCESS_ID = msii.SET_PROCESS_ID
2231: AND miri.PROCESS_FLAG = 1

Line 2356: FROM MTL_ITEM_REVISIONS_INTERFACE miri,

2352: miri.SOURCE_SYSTEM_REFERENCE,
2353: NULL AS BUNDLE_ID,
2354: miri.TRANSACTION_ID,
2355: ext_prod.EXTENSION_ID, #' || G_PROD_COL_LIST || q'#
2356: FROM MTL_ITEM_REVISIONS_INTERFACE miri,
2357: EGO_MTL_SY_ITEMS_EXT_VL ext_prod
2358: WHERE miri.SET_PROCESS_ID = #' || p_batch_id || q'#
2359: AND miri.TRANSACTION_TYPE = 'CREATE'
2360: AND miri.PROCESS_FLAG = 1

Line 2381: FROM MTL_ITEM_REVISIONS_INTERFACE miri,

2377:
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

Line 4451: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri

4447: END IF;
4448:
4449: Debug_Conc_Log('Enable_Disable_SKU_Processing: MTL_SYSTEM_ITEMS_INTERFACE Processed rows='||SQL%ROWCOUNT);
4450:
4451: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri
4452: SET PROCESS_FLAG = 10
4453: WHERE SET_PROCESS_ID = p_batch_id
4454: AND PROCESS_FLAG = 1
4455: AND EXISTS (SELECT NULL FROM MTL_SYSTEM_ITEMS_INTERFACE msii

Line 4473: Debug_Conc_Log('Enable_Disable_SKU_Processing: MTL_ITEM_REVISIONS_INTERFACE Processed rows='||SQL%ROWCOUNT);

4469: IF SQL%ROWCOUNT > 0 THEN
4470: EGO_WF_WRAPPER_PVT.Set_Rev_Change_Bus_Event(p_true_false => p_enable_sku_processing);
4471: END IF;
4472:
4473: Debug_Conc_Log('Enable_Disable_SKU_Processing: MTL_ITEM_REVISIONS_INTERFACE Processed rows='||SQL%ROWCOUNT);
4474:
4475: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici
4476: SET PROCESS_FLAG = 10
4477: WHERE SET_PROCESS_ID = p_batch_id

Line 4639: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri

4635:
4636: Debug_Conc_Log('Enable_Disable_SKU_Processing - Done Updating Copy Item Id cnt-'||SQL%ROWCOUNT );
4637: END IF;
4638:
4639: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri
4640: SET PROCESS_FLAG = 1
4641: WHERE SET_PROCESS_ID = p_batch_id
4642: AND PROCESS_FLAG = 10;
4643:

Line 4648: Debug_Conc_Log('Enable_Disable_SKU_Processing: MTL_ITEM_REVISIONS_INTERFACE Processed rows='||SQL%ROWCOUNT);

4644: --R12C Business Events to be fired only ONCE although Batch Import is called twice for Styles and then SKUs
4645: IF SQL%ROWCOUNT > 0 THEN
4646: EGO_WF_WRAPPER_PVT.Set_Rev_Change_Bus_Event(p_true_false => p_enable_sku_processing);
4647: END IF;
4648: Debug_Conc_Log('Enable_Disable_SKU_Processing: MTL_ITEM_REVISIONS_INTERFACE Processed rows='||SQL%ROWCOUNT);
4649:
4650: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici
4651: SET PROCESS_FLAG = 1
4652: WHERE SET_PROCESS_ID = p_batch_id

Line 5177: UPDATE MTL_ITEM_REVISIONS_INTERFACE

5173: );
5174: END LOOP;
5175: END IF;
5176:
5177: UPDATE MTL_ITEM_REVISIONS_INTERFACE
5178: SET ITEM_NUMBER = p_item_number
5179: WHERE PROCESS_FLAG = 1
5180: AND SET_PROCESS_ID = p_batch_id
5181: AND SOURCE_SYSTEM_ID = p_ss_id

Line 5628: FROM mtl_item_revisions_interface

5624: BEGIN
5625: SELECT error_message BULK COLLECT INTO l_rev_err_table
5626: FROM mtl_interface_errors
5627: WHERE transaction_id IN ( SELECT transaction_id
5628: FROM mtl_item_revisions_interface
5629: WHERE set_process_id = p_batch_id
5630: AND process_flag = 3);
5631: EXCEPTION
5632: WHEN no_data_found THEN

Line 5727: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri

5723: SET PROCESS_FLAG = DECODE(PROCESS_FLAG, 4, 16, 4)
5724: WHERE SET_PROCESS_ID = p_batch_id
5725: AND PROCESS_FLAG IN ( 4, 14 );
5726:
5727: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri
5728: SET PROCESS_FLAG = 6,
5729: REQUEST_ID = l_request_id,
5730: PROGRAM_ID = l_prog_id,
5731: PROGRAM_APPLICATION_ID = l_prog_appid,

Line 5737: FROM MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_ITEM_REVISIONS_INTERFACE miri2

5733: LAST_UPDATED_BY = l_user_id
5734: WHERE SET_PROCESS_ID = p_batch_id
5735: AND PROCESS_FLAG = 1
5736: AND ROWID <> (SELECT MIN(miri2.ROWID)
5737: FROM MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_ITEM_REVISIONS_INTERFACE miri2
5738: WHERE msii.INVENTORY_ITEM_ID = miri2.INVENTORY_ITEM_ID
5739: AND msii.ORGANIZATION_ID = miri2.ORGANIZATION_ID
5740: AND msii.SET_PROCESS_ID = miri2.SET_PROCESS_ID
5741: AND msii.SET_PROCESS_ID = miri.SET_PROCESS_ID