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_VL

Line 291: FROM bom_bill_of_mtls_interface BBMI,mtl_system_items_vl MSIVL,mtl_parameters MP,bom_structures_b BSB

287: BEGIN
288:
289: SELECT item_number
290: INTO l_temp
291: FROM bom_bill_of_mtls_interface BBMI,mtl_system_items_vl MSIVL,mtl_parameters MP,bom_structures_b BSB
292: WHERE BBMI.batch_id = p_batch_id
293: AND BSB.bill_sequence_id = p_bill_seq_id
294: AND (BBMI.process_flag = 1 OR BBMI.process_flag = 5 )
295: AND (( BBMI.request_id IS NOT NULL AND BBMI.request_id = p_request_id ) OR (BBMI.bundle_id IS NOT NULL AND BBMI.bundle_id = p_bundle_id))

Line 1507: FROM mtl_system_items_vl

1503:
1504: IF l_item_id_table(i) IS NULL THEN
1505: SELECT inventory_item_id
1506: INTO l_item_id_table(i)
1507: FROM mtl_system_items_vl
1508: WHERE (concatenated_segments = l_header_rec_table(i) OR concatenated_segments = l_item_name_table(i))
1509: AND organization_id = l_org_id_table(i);
1510: END IF;
1511:

Line 1600: FROM mtl_system_items_vl

1596: BEGIN
1597: IF l_comp_table(j).component_item_id IS NULL THEN
1598: SELECT inventory_item_id
1599: INTO l_comp_table(j).component_item_id
1600: FROM mtl_system_items_vl
1601: WHERE concatenated_segments = l_comp_table(j).component_item_number
1602: AND organization_id = l_org_id_table(i);
1603: END IF;
1604: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 4137: FROM mtl_system_items_vl

4133: IF l_head_name_table(i) IS NULL
4134: THEN
4135: SELECT concatenated_segments
4136: INTO l_head_name_table(i)
4137: FROM mtl_system_items_vl
4138: WHERE inventory_item_id = l_head_item_id_table(i)
4139: AND organization_id = l_org_id_table(i);
4140: END IF;
4141:

Line 4207: FROM mtl_system_items_vl

4203: IF l_comp_name_table(i) IS NULL
4204: THEN
4205: SELECT concatenated_segments
4206: INTO l_comp_name_table(i)
4207: FROM mtl_system_items_vl
4208: WHERE inventory_item_id = l_comp_item_id_table(i)
4209: AND organization_id = l_org_id_table(i);
4210: END IF;
4211:

Line 4226: FROM mtl_system_items_vl

4222: IF l_head_name_table(i) IS NULL
4223: THEN
4224: SELECT concatenated_segments
4225: INTO l_head_name_table(i)
4226: FROM mtl_system_items_vl
4227: WHERE inventory_item_id = l_head_item_id_table(i)
4228: AND organization_id = l_org_id_table(i);
4229: END IF;
4230:

Line 4592: FROM mtl_system_items_vl

4588:
4589: IF l_item_id_table(i) IS NULL THEN
4590: SELECT inventory_item_id
4591: INTO l_item_id_table(i)
4592: FROM mtl_system_items_vl
4593: WHERE concatenated_segments = l_header_rec_table(i)
4594: AND organization_id = l_org_id_table(i);
4595: END IF;
4596:

Line 4631: FROM mtl_system_items_vl

4627: BEGIN
4628: IF l_comp_table(j).component_item_id IS NULL THEN
4629: SELECT inventory_item_id
4630: INTO l_comp_table(j).component_item_id
4631: FROM mtl_system_items_vl
4632: WHERE concatenated_segments = l_comp_table(j).comp_source_system_reference
4633: AND organization_id = l_org_id_table(i);
4634: END IF;
4635: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 4704: (SELECT concatenated_segments FROM mtl_system_items_vl MSIVL

4700: l_unmatch_comp(m).component_item_id,
4701: l_org_id_table(i),
4702: l_unmatch_comp(m).component_sequence_id,
4703: l_unmatch_comp(m).bill_sequence_id,
4704: (SELECT concatenated_segments FROM mtl_system_items_vl MSIVL
4705: WHERE MSIVL.inventory_item_id = l_comp_pdh_table(k).component_item_id
4706: AND organization_id = l_org_id_table(i)),
4707: p_batch_id,
4708: 'DELETE',

Line 4711: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_unmatch_comp(m).component_item_id AND organization_id = l_org_id_table(i)),

4707: p_batch_id,
4708: 'DELETE',
4709: SYSDATE,
4710: 1,
4711: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_unmatch_comp(m).component_item_id AND organization_id = l_org_id_table(i)),
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,

Line 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)),

4708: 'DELETE',
4709: SYSDATE,
4710: 1,
4711: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_unmatch_comp(m).component_item_id AND organization_id = l_org_id_table(i)),
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

Line 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)),

4841: p_batch_id,
4842: 'DELETE',
4843: SYSDATE,
4844: 1,
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

Line 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)),

4842: 'DELETE',
4843: SYSDATE,
4844: 1,
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: );

Line 4903: (SELECT concatenated_segments FROM mtl_system_items_vl MSIVL

4899: l_unmatch_comp(m).component_item_id,
4900: l_org_id_table(i),
4901: l_unmatch_comp(m).component_sequence_id,
4902: l_unmatch_comp(m).bill_sequence_id,
4903: (SELECT concatenated_segments FROM mtl_system_items_vl MSIVL
4904: WHERE MSIVL.inventory_item_id = l_comp_pdh_table(j).component_item_id
4905: AND organization_id = l_org_id_table(i)),
4906: p_batch_id,
4907: 'DELETE',

Line 4910: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_unmatch_comp(m).component_item_id AND organization_id = l_org_id_table(i)),

4906: p_batch_id,
4907: 'DELETE',
4908: SYSDATE,
4909: 1,
4910: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_unmatch_comp(m).component_item_id AND organization_id = l_org_id_table(i)),
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 ,

Line 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)),

4907: 'DELETE',
4908: SYSDATE,
4909: 1,
4910: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_unmatch_comp(m).component_item_id AND organization_id = l_org_id_table(i)),
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

Line 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)),

5028: p_batch_id,
5029: 'DELETE',
5030: SYSDATE,
5031: 1,
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

Line 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)),

5029: 'DELETE',
5030: SYSDATE,
5031: 1,
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: );