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 331: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

327: BEGIN
328: update
329: BOM_BILL_OF_MTLS_INTERFACE
330: set
331: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
332: where
333: transaction_id is null
334: and batch_id = p_batch_id
335: and process_flag = 1;

Line 340: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

336:
337: update
338: BOM_INVENTORY_COMPS_INTERFACE
339: set
340: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
341: where
342: transaction_id is null
343: and batch_id = p_batch_id
344: and process_flag = 1;

Line 349: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

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

Line 358: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

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

Line 708: mtl_system_items_interface MSII

704: 'Exist'
705: INTO
706: l_dummy
707: FROM
708: mtl_system_items_interface MSII
709: WHERE
710: MSII.set_process_id = p_batch_id
711: AND ( (MSII.source_system_reference = p_ss_reference AND MSII.source_system_reference_desc = p_ss_desc )
712: OR(MSII.item_number = p_item_number AND MSII.description = p_item_desc)

Line 1120: FROM bom_bill_of_mtls_interface BBMI,mtl_system_items_interface MSII

1116: l_request_id NUMBER := nvl(FND_GLOBAL.conc_request_id,-1);
1117: CURSOR Process_Header
1118: IS
1119: SELECT MSII.inventory_item_id,MSII.organization_id,MSII.source_system_reference,MSII.item_number
1120: FROM bom_bill_of_mtls_interface BBMI,mtl_system_items_interface MSII
1121: WHERE BBMI.batch_id = p_batch_id
1122: AND (BBMI.process_flag = 1 OR BBMI.process_flag = 5)
1123: AND MSII.set_process_id = BBMI.batch_id
1124: AND MSII.process_flag IN (0,1,7)

Line 1132: FROM bom_inventory_comps_interface BICI,mtl_system_items_interface MSII

1128:
1129: CURSOR Process_Comp
1130: IS
1131: SELECT MSII.inventory_item_id,MSII.organization_id,MSII.source_system_reference,MSII.item_number
1132: FROM bom_inventory_comps_interface BICI,mtl_system_items_interface MSII
1133: WHERE BICI.batch_id = p_batch_id
1134: AND (BICI.process_flag = 1 OR BICI.process_flag = 5)
1135: AND MSII.set_process_id = BICI.batch_id
1136: AND MSII.process_flag IN (0,1,7)

Line 1144: FROM bom_inventory_comps_interface BICI,mtl_system_items_interface MSII

1140:
1141: Cursor Process_Header_For_Comp
1142: IS
1143: SELECT MSII.inventory_item_id,MSII.organization_id,MSII.source_system_reference,MSII.item_number
1144: FROM bom_inventory_comps_interface BICI,mtl_system_items_interface MSII
1145: WHERE BICI.batch_id = p_batch_id
1146: AND (BICI.process_flag = 1 OR BICI.process_flag = 5)
1147: AND MSII.set_process_id = BICI.batch_id
1148: AND MSII.process_flag IN (0,1,7)

Line 1900: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE

1896: LOOP
1897: 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))
1898: THEN
1899: Write_Debug('Inserting into Mtl_Interface for Header');
1900: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
1901: ( set_process_id
1902: , source_system_id
1903: , source_system_reference
1904: , SOURCE_SYSTEM_REFERENCE_DESC

Line 1960: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE

1956: 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))
1957: THEN
1958: Write_Debug('Inserting into Mtl_Interface for Comps');
1959:
1960: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
1961: (
1962: set_process_id
1963: , source_system_id
1964: , source_system_reference

Line 3317: mtl_system_items_interface

3313: SELECT COUNT(*) INTO l_item_infcrows_exists FROM
3314: ( SELECT
3315: 'X'
3316: FROM
3317: mtl_system_items_interface
3318: WHERE EXISTS
3319: (SELECT
3320: process_flag
3321: FROM

Line 3322: mtl_system_items_interface

3318: WHERE EXISTS
3319: (SELECT
3320: process_flag
3321: FROM
3322: mtl_system_items_interface
3323: WHERE
3324: set_process_id = p_batch_id
3325: AND process_flag = 1
3326: UNION ALL

Line 3401: mtl_system_items_interface

3397: organization_id,
3398: confirm_status,
3399: process_flag
3400: FROM
3401: mtl_system_items_interface
3402: WHERE
3403: set_process_id = p_batch_id
3404: AND confirm_status IN ('US','UM','UN','EX');
3405:

Line 3414: mtl_system_items_interface

3410: organization_id,
3411: confirm_status,
3412: process_flag
3413: FROM
3414: mtl_system_items_interface
3415: WHERE
3416: set_process_id = p_batch_id
3417: AND confirm_status IN ('CC','CM','CN');
3418:

Line 3963: FROM mtl_system_items_interface

3959: FOR i IN 1..l_count
3960: LOOP
3961: SELECT inventory_item_id
3962: INTO l_item_id
3963: FROM mtl_system_items_interface
3964: WHERE set_process_id = p_batch_id
3965: AND source_system_reference = p_ssRef_varray(i);
3966:
3967: --Update the header

Line 4324: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

4320: (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)),
4321: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4322: l_str_name(i),
4323: l_comp_pdh_table(k).component_item_id,
4324: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
4325: );
4326:
4327: Disable_Refds
4328: (

Line 4457: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

4453: (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)),
4454: (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)),
4455: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4456: l_str_name(i),
4457: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
4458: );
4459: END IF;
4460: Disable_Refds
4461: (

Line 4523: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

4519: (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)),
4520: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4521: l_str_name(i),
4522: l_comp_pdh_table(j).component_item_id ,
4523: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
4524: );
4525:
4526: Disable_Refds
4527: (

Line 4644: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

4640: (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)),
4641: (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)),
4642: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4643: l_str_name(i),
4644: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
4645: );
4646: END IF;
4647: Disable_Refds
4648: (

Line 4708: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

4704: IS
4705: L_NEXT_VALUE NUMBER;
4706: BEGIN
4707: SELECT
4708: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
4709: INTO
4710: L_NEXT_VALUE
4711: FROM DUAL;
4712: RETURN L_NEXT_VALUE;