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 168: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI

164: l_msg_count NUMBER;
165: l_msg_data VARCHAR2(4000);
166: BEGIN
167: Debug_Conc_Log('Resolve_PKs_For_Child: Starting ');
168: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
169: SET INVENTORY_ITEM_ID = NVL((SELECT INVENTORY_ITEM_ID
170: FROM MTL_SYSTEM_ITEMS_KFV MSIK
171: WHERE MSIK.CONCATENATED_SEGMENTS = MIRI.ITEM_NUMBER
172: AND MSIK.ORGANIZATION_ID = MIRI.ORGANIZATION_ID

Line 301: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

297: AND MIRB.ORGANIZATION_ID = EIUAI.ORGANIZATION_ID
298: AND MIRB.REVISION = EIUAI.REVISION
299: ),
300: (SELECT REVISION_ID
301: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI
302: WHERE MIRI.INVENTORY_ITEM_ID = EIUAI.INVENTORY_ITEM_ID
303: AND MIRI.ORGANIZATION_ID = EIUAI.ORGANIZATION_ID
304: AND MIRI.REVISION = EIUAI.REVISION
305: AND MIRI.SET_PROCESS_ID = EIUAI.DATA_SET_ID

Line 609: MTL_ITEM_REVISIONS_INTERFACE MIRI

605: MIRI.REVISION_ID, #' ||
606: l_item_rev_dl_id || q'# AS DATA_LEVEL_ID
607: FROM
608: MTL_SYSTEM_ITEMS_INTERFACE MSII,
609: MTL_ITEM_REVISIONS_INTERFACE MIRI
610: WHERE MSII.ITEM_CATALOG_GROUP_ID IS NOT NULL
611: AND MSII.SET_PROCESS_ID = #' || p_batch_id || q'#
612: AND MSII.PROCESS_FLAG = 1
613: AND MSII.SET_PROCESS_ID = MIRI.SET_PROCESS_ID

Line 713: MTL_ITEM_REVISIONS_INTERFACE MIRI,

709: NULL AS PK5_VALUE,
710: MIRI.REVISION_ID, #' ||
711: l_item_rev_dl_id || q'# AS DATA_LEVEL_ID
712: FROM
713: MTL_ITEM_REVISIONS_INTERFACE MIRI,
714: MTL_SYSTEM_ITEMS_B MSIB
715: WHERE MSIB.ITEM_CATALOG_GROUP_ID IS NOT NULL
716: AND MIRI.TEMPLATE_ID IS NOT NULL
717: AND MIRI.INVENTORY_ITEM_ID = MSIB.INVENTORY_ITEM_ID

Line 753: MTL_ITEM_REVISIONS_INTERFACE MIRI

749: END) REVISION_ID, #' ||
750: l_item_rev_dl_id || q'# AS DATA_LEVEL_ID
751: FROM
752: MTL_SYSTEM_ITEMS_INTERFACE MSII,
753: MTL_ITEM_REVISIONS_INTERFACE MIRI
754: WHERE MSII.ITEM_CATALOG_GROUP_ID IS NOT NULL
755: AND MSII.TEMPLATE_ID IS NOT NULL
756: AND MIRI.INVENTORY_ITEM_ID(+) = MSII.INVENTORY_ITEM_ID
757: AND MIRI.ORGANIZATION_ID(+) = MSII.ORGANIZATION_ID

Line 931: FROM MTL_ITEM_REVISIONS_INTERFACE miri

927: IF i.DATA_LEVEL_NAME = 'ITEM_REVISION_LEVEL' THEN
928: l_rev_where_clause := ' AND msii.COPY_REVISION_ID = ext_prod.REVISION_ID';
929: l_pk_where := ' AND ext_prod.PK1_VALUE IS NULL AND ext_prod.PK2_VALUE IS NULL ';
930: l_rev_id_sql := q'#(SELECT MAX(miri.REVISION_ID) KEEP (DENSE_RANK FIRST ORDER BY miri.REVISION)
931: FROM MTL_ITEM_REVISIONS_INTERFACE miri
932: WHERE miri.INVENTORY_ITEM_ID = msii.INVENTORY_ITEM_ID
933: AND miri.ORGANIZATION_ID = msii.ORGANIZATION_ID
934: AND miri.SET_PROCESS_ID = msii.SET_PROCESS_ID
935: AND miri.PROCESS_FLAG = 1

Line 1161: MTL_ITEM_REVISIONS_INTERFACE miri

1157: NULL AS PK5_VALUE,
1158: #' || l_item_rev_dl_id || q'# AS DATA_LEVEL_ID
1159: FROM
1160: MTL_SYSTEM_ITEMS_INTERFACE msii,
1161: MTL_ITEM_REVISIONS_INTERFACE miri
1162: WHERE miri.INVENTORY_ITEM_ID = msii.INVENTORY_ITEM_ID
1163: AND miri.ORGANIZATION_ID = msii.ORGANIZATION_ID
1164: AND msii.ITEM_CATALOG_GROUP_ID IS NOT NULL
1165: AND miri.SET_PROCESS_ID = msii.SET_PROCESS_ID

Line 2402: FROM MTL_ITEM_REVISIONS_INTERFACE miri

2398: ext_prod.ITEM_CATALOG_GROUP_ID,
2399: ext_prod.ATTR_GROUP_ID,
2400: ext_prod.DATA_LEVEL_ID,
2401: (SELECT MAX(miri.REVISION_ID) KEEP (DENSE_RANK FIRST ORDER BY miri.REVISION)
2402: FROM MTL_ITEM_REVISIONS_INTERFACE miri
2403: WHERE miri.INVENTORY_ITEM_ID = msii.INVENTORY_ITEM_ID
2404: AND miri.ORGANIZATION_ID = msii.ORGANIZATION_ID
2405: AND miri.SET_PROCESS_ID = msii.SET_PROCESS_ID
2406: AND miri.PROCESS_FLAG = #' || p_msii_miri_process_flag || q'#

Line 2541: FROM MTL_ITEM_REVISIONS_INTERFACE miri,

2537: miri.SOURCE_SYSTEM_REFERENCE,
2538: NULL AS BUNDLE_ID,
2539: miri.TRANSACTION_ID,
2540: ext_prod.EXTENSION_ID, #' || G_PROD_COL_LIST || q'#
2541: FROM MTL_ITEM_REVISIONS_INTERFACE miri,
2542: EGO_MTL_SY_ITEMS_EXT_VL ext_prod
2543: WHERE miri.SET_PROCESS_ID = #' || p_batch_id || q'#
2544: AND miri.TRANSACTION_TYPE = 'CREATE'
2545: AND miri.PROCESS_FLAG = #' || p_msii_miri_process_flag || q'#

Line 2568: FROM MTL_ITEM_REVISIONS_INTERFACE miri,

2564:
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'#

Line 5150: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri

5146: END IF;
5147:
5148: Debug_Conc_Log('Enable_Disable_SKU_Processing: MTL_SYSTEM_ITEMS_INTERFACE Processed rows='||SQL%ROWCOUNT);
5149:
5150: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri
5151: SET PROCESS_FLAG = 10
5152: WHERE SET_PROCESS_ID = p_batch_id
5153: AND PROCESS_FLAG = 1
5154: AND EXISTS (SELECT NULL FROM MTL_SYSTEM_ITEMS_INTERFACE msii

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

5168: IF SQL%ROWCOUNT > 0 THEN
5169: EGO_WF_WRAPPER_PVT.Set_Rev_Change_Bus_Event(p_true_false => p_enable_sku_processing);
5170: END IF;
5171:
5172: Debug_Conc_Log('Enable_Disable_SKU_Processing: MTL_ITEM_REVISIONS_INTERFACE Processed rows='||SQL%ROWCOUNT);
5173:
5174: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici
5175: SET PROCESS_FLAG = 10
5176: WHERE SET_PROCESS_ID = p_batch_id

Line 5349: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri

5345:
5346: Debug_Conc_Log('Enable_Disable_SKU_Processing - Done Updating Copy Item Id cnt-'||SQL%ROWCOUNT );
5347: END IF;
5348:
5349: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri
5350: SET PROCESS_FLAG = 1
5351: WHERE SET_PROCESS_ID = p_batch_id
5352: AND PROCESS_FLAG = 10;
5353:

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

5362: EGO_WF_WRAPPER_PVT.Set_Rev_Change_Bus_Event(p_true_false => p_enable_sku_processing);
5363: ELSE
5364: EGO_WF_WRAPPER_PVT.Set_Rev_Change_Bus_Event(p_true_false => 'F'); -- Bug #9341964, make sure biz event is fired only once
5365: END IF;
5366: Debug_Conc_Log('Enable_Disable_SKU_Processing: MTL_ITEM_REVISIONS_INTERFACE Processed rows='||SQL%ROWCOUNT);
5367:
5368: UPDATE MTL_ITEM_CATEGORIES_INTERFACE mici
5369: SET PROCESS_FLAG = 1
5370: WHERE SET_PROCESS_ID = p_batch_id

Line 5928: --UPDATE MTL_ITEM_REVISIONS_INTERFACE

5924: END LOOP;
5925: END IF;
5926:
5927: -- Fix for bug#9660659 Start
5928: --UPDATE MTL_ITEM_REVISIONS_INTERFACE
5929: --SET ITEM_NUMBER = p_item_number
5930: --WHERE PROCESS_FLAG = 1
5931: -- AND SET_PROCESS_ID = p_batch_id
5932: -- AND SOURCE_SYSTEM_ID = p_ss_id

Line 5936: UPDATE MTL_ITEM_REVISIONS_INTERFACE

5932: -- AND SOURCE_SYSTEM_ID = p_ss_id
5933: -- AND ( ITEM_NUMBER = p_old_item_number OR SOURCE_SYSTEM_REFERENCE = p_ss_ref );
5934:
5935: IF(p_ss_ref IS NOT null) THEN
5936: UPDATE MTL_ITEM_REVISIONS_INTERFACE
5937: SET ITEM_NUMBER = p_item_number
5938: WHERE PROCESS_FLAG = 1
5939: AND SET_PROCESS_ID = p_batch_id
5940: AND SOURCE_SYSTEM_ID = p_ss_id

Line 5943: UPDATE MTL_ITEM_REVISIONS_INTERFACE

5939: AND SET_PROCESS_ID = p_batch_id
5940: AND SOURCE_SYSTEM_ID = p_ss_id
5941: AND SOURCE_SYSTEM_REFERENCE = p_ss_ref;
5942: ELSE
5943: UPDATE MTL_ITEM_REVISIONS_INTERFACE
5944: SET ITEM_NUMBER = p_item_number
5945: WHERE PROCESS_FLAG = 1
5946: AND SET_PROCESS_ID = p_batch_id
5947: AND ITEM_NUMBER = p_old_item_number;

Line 6412: FROM mtl_item_revisions_interface

6408: BEGIN
6409: SELECT error_message BULK COLLECT INTO l_rev_err_table
6410: FROM mtl_interface_errors
6411: WHERE transaction_id IN ( SELECT transaction_id
6412: FROM mtl_item_revisions_interface
6413: WHERE set_process_id = p_batch_id
6414: AND process_flag = 3);
6415: EXCEPTION
6416: WHEN no_data_found THEN

Line 6511: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri

6507: SET PROCESS_FLAG = DECODE(PROCESS_FLAG, 4, 16, 4)
6508: WHERE SET_PROCESS_ID = p_batch_id
6509: AND PROCESS_FLAG IN ( 4, 14 );
6510:
6511: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri
6512: SET PROCESS_FLAG = 6,
6513: REQUEST_ID = l_request_id,
6514: PROGRAM_ID = l_prog_id,
6515: PROGRAM_APPLICATION_ID = l_prog_appid,

Line 6521: FROM MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_ITEM_REVISIONS_INTERFACE miri2

6517: LAST_UPDATED_BY = l_user_id
6518: WHERE SET_PROCESS_ID = p_batch_id
6519: AND PROCESS_FLAG = 1
6520: AND ROWID <> (SELECT MIN(miri2.ROWID)
6521: FROM MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_ITEM_REVISIONS_INTERFACE miri2
6522: WHERE msii.INVENTORY_ITEM_ID = miri2.INVENTORY_ITEM_ID
6523: AND msii.ORGANIZATION_ID = miri2.ORGANIZATION_ID
6524: AND msii.SET_PROCESS_ID = miri2.SET_PROCESS_ID
6525: AND msii.SET_PROCESS_ID = miri.SET_PROCESS_ID