APPS.BOM_IMPORT_PUB dependencies on MTL_PARAMETERS

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 1499: FROM mtl_parameters

1495: BEGIN
1496: IF l_org_id_table(i) IS NULL THEN
1497: SELECT organization_id
1498: INTO l_org_id_table(i)
1499: FROM mtl_parameters
1500: WHERE organization_code = l_org_code_table(i);
1501: END IF;
1502:
1503:

Line 4119: FROM mtl_parameters

4115: IF l_org_id_table(i) IS NULL
4116: THEN
4117: SELECT organization_id
4118: INTO l_org_id_table(i)
4119: FROM mtl_parameters
4120: WHERE organization_code = l_org_code_table(i);
4121: END IF;
4122:
4123: IF l_head_item_id_table(i) IS NULL

Line 4190: FROM mtl_parameters

4186: IF l_org_id_table(i) IS NULL
4187: THEN
4188: SELECT organization_id
4189: INTO l_org_id_table(i)
4190: FROM mtl_parameters
4191: WHERE organization_code = l_org_code_table(i);
4192: END IF;
4193:
4194: IF l_comp_item_id_table(i) IS NULL

Line 4584: FROM mtl_parameters

4580: BEGIN
4581: IF l_org_id_table(i) IS NULL THEN
4582: SELECT organization_id
4583: INTO l_org_id_table(i)
4584: FROM mtl_parameters
4585: WHERE organization_code = l_org_code_table(i);
4586: END IF;
4587:
4588:

Line 4713: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),

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
4717: );

Line 4847: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),

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: );
4851: END IF;

Line 4912: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),

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
4916: );

Line 5034: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),

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: );
5038: END IF;