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.BOM_IMPORT_PUB dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 338: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

334: BEGIN
335: update
336: BOM_BILL_OF_MTLS_INTERFACE
337: set
338: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
339: where
340: transaction_id is null
341: and batch_id = p_batch_id
342: and process_flag = 1;

Line 347: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

343:
344: update
345: BOM_INVENTORY_COMPS_INTERFACE
346: set
347: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
348: where
349: transaction_id is null
350: and batch_id = p_batch_id
351: and process_flag = 1;

Line 356: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

352:
353: update
354: BOM_SUB_COMPS_INTERFACE
355: set
356: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
357: where
358: transaction_id is null
359: and batch_id = p_batch_id
360: and process_flag = 1;

Line 365: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

361:
362: update
363: BOM_REF_DESGS_INTERFACE
364: set
365: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
366: where
367: transaction_id is null
368: and batch_id = p_batch_id
369: and process_flag = 1;

Line 834: mtl_system_items_interface MSII

830: 'Exist'
831: INTO
832: l_dummy
833: FROM
834: mtl_system_items_interface MSII
835: WHERE
836: MSII.set_process_id = p_batch_id
837: AND ( (MSII.source_system_reference = p_ss_reference AND MSII.source_system_reference_desc = p_ss_desc )
838: OR(MSII.item_number = p_item_number AND MSII.description = p_item_desc)

Line 1261: FROM bom_bill_of_mtls_interface BBMI,mtl_system_items_interface MSII

1257: l_request_id NUMBER := nvl(FND_GLOBAL.conc_request_id,-1);
1258: CURSOR Process_Header
1259: IS
1260: SELECT MSII.inventory_item_id,MSII.organization_id,MSII.source_system_reference,MSII.item_number
1261: FROM bom_bill_of_mtls_interface BBMI,mtl_system_items_interface MSII
1262: WHERE BBMI.batch_id = p_batch_id
1263: AND (BBMI.process_flag = 1 OR BBMI.process_flag = 5)
1264: AND MSII.set_process_id = BBMI.batch_id
1265: AND MSII.process_flag IN (0,1,7)

Line 1273: FROM bom_inventory_comps_interface BICI,mtl_system_items_interface MSII

1269:
1270: CURSOR Process_Comp
1271: IS
1272: SELECT MSII.inventory_item_id,MSII.organization_id,MSII.source_system_reference,MSII.item_number
1273: FROM bom_inventory_comps_interface BICI,mtl_system_items_interface MSII
1274: WHERE BICI.batch_id = p_batch_id
1275: AND (BICI.process_flag = 1 OR BICI.process_flag = 5)
1276: AND MSII.set_process_id = BICI.batch_id
1277: AND MSII.process_flag IN (0,1,7)

Line 1285: FROM bom_inventory_comps_interface BICI,mtl_system_items_interface MSII

1281:
1282: Cursor Process_Header_For_Comp
1283: IS
1284: SELECT MSII.inventory_item_id,MSII.organization_id,MSII.source_system_reference,MSII.item_number
1285: FROM bom_inventory_comps_interface BICI,mtl_system_items_interface MSII
1286: WHERE BICI.batch_id = p_batch_id
1287: AND (BICI.process_flag = 1 OR BICI.process_flag = 5)
1288: AND MSII.set_process_id = BICI.batch_id
1289: AND MSII.process_flag IN (0,1,7)

Line 2043: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE

2039: LOOP
2040: IF NOT Item_Exist_In_Mtl_Intf(l_ss_ref_table(i),p_batch_id,l_org_code_table(i),l_item_number_table(i),l_ss_desc_table(i),l_item_desc_table(i),l_org_id_table(i))
2041: THEN
2042: Write_Debug('Inserting into Mtl_Interface for Header');
2043: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
2044: ( set_process_id
2045: , source_system_id
2046: , source_system_reference
2047: , SOURCE_SYSTEM_REFERENCE_DESC

Line 2103: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE

2099: IF NOT Item_Exist_In_Mtl_Intf(l_ss_ref_table(i),p_batch_id,l_org_code_table(i),l_item_number_table(i),l_ss_desc_table(i),l_item_desc_table(i),l_org_id_table(i))
2100: THEN
2101: Write_Debug('Inserting into Mtl_Interface for Comps');
2102:
2103: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
2104: (
2105: set_process_id
2106: , source_system_id
2107: , source_system_reference

Line 3709: mtl_system_items_interface

3705: SELECT COUNT(*) INTO l_item_infcrows_exists FROM
3706: ( SELECT
3707: 'X'
3708: FROM
3709: mtl_system_items_interface
3710: WHERE EXISTS
3711: (SELECT
3712: process_flag
3713: FROM

Line 3714: mtl_system_items_interface

3710: WHERE EXISTS
3711: (SELECT
3712: process_flag
3713: FROM
3714: mtl_system_items_interface
3715: WHERE
3716: set_process_id = p_batch_id
3717: AND process_flag = 1
3718: UNION ALL

Line 3793: mtl_system_items_interface

3789: organization_id,
3790: confirm_status,
3791: process_flag
3792: FROM
3793: mtl_system_items_interface
3794: WHERE
3795: set_process_id = p_batch_id
3796: AND confirm_status IN ('US','UM','UN','EX');
3797:

Line 3806: mtl_system_items_interface

3802: organization_id,
3803: confirm_status,
3804: process_flag
3805: FROM
3806: mtl_system_items_interface
3807: WHERE
3808: set_process_id = p_batch_id
3809: AND confirm_status IN ('CC','CM','CN');
3810:

Line 4355: FROM mtl_system_items_interface

4351: FOR i IN 1..l_count
4352: LOOP
4353: SELECT inventory_item_id
4354: INTO l_item_id
4355: FROM mtl_system_items_interface
4356: WHERE set_process_id = p_batch_id
4357: AND source_system_reference = p_ssRef_varray(i);
4358:
4359: --Update the header

Line 4716: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

4712: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_comp_pdh_table(k).component_item_id AND organization_id = l_org_id_table(i)),
4713: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4714: l_str_name(i),
4715: l_comp_pdh_table(k).component_item_id,
4716: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
4717: );
4718:
4719: Disable_Refds
4720: (

Line 4849: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

4845: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id =l_comp_pdh_table(k).component_item_id AND organization_id = l_org_id_table(i)),
4846: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_item_id_table(i) AND organization_id = l_org_id_table(i)),
4847: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4848: l_str_name(i),
4849: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
4850: );
4851: END IF;
4852: Disable_Refds
4853: (

Line 4915: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

4911: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_comp_pdh_table(j).component_item_id AND organization_id = l_org_id_table(i)),
4912: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4913: l_str_name(i),
4914: l_comp_pdh_table(j).component_item_id ,
4915: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
4916: );
4917:
4918: Disable_Refds
4919: (

Line 5036: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

5032: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id =l_comp_pdh_table(j).component_item_id AND organization_id = l_org_id_table(i)),
5033: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_item_id_table(i) AND organization_id = l_org_id_table(i)),
5034: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
5035: l_str_name(i),
5036: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
5037: );
5038: END IF;
5039: Disable_Refds
5040: (

Line 5100: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

5096: IS
5097: L_NEXT_VALUE NUMBER;
5098: BEGIN
5099: SELECT
5100: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
5101: INTO
5102: L_NEXT_VALUE
5103: FROM DUAL;
5104: RETURN L_NEXT_VALUE;