APPS.BOM_IMPORT_PUB dependencies on MTL_PARAMETERS

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

280: BEGIN
281:
282: SELECT item_number
283: INTO l_temp
284: FROM bom_bill_of_mtls_interface BBMI,mtl_system_items_vl MSIVL,mtl_parameters MP,bom_structures_b BSB
285: WHERE BBMI.batch_id = p_batch_id
286: AND BSB.bill_sequence_id = p_bill_seq_id
287: AND (BBMI.process_flag = 1 OR BBMI.process_flag = 5 )
288: 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 1358: FROM mtl_parameters

1354: BEGIN
1355: IF l_org_id_table(i) IS NULL THEN
1356: SELECT organization_id
1357: INTO l_org_id_table(i)
1358: FROM mtl_parameters
1359: WHERE organization_code = l_org_code_table(i);
1360: END IF;
1361:
1362:

Line 3727: FROM mtl_parameters

3723: IF l_org_id_table(i) IS NULL
3724: THEN
3725: SELECT organization_id
3726: INTO l_org_id_table(i)
3727: FROM mtl_parameters
3728: WHERE organization_code = l_org_code_table(i);
3729: END IF;
3730:
3731: IF l_head_item_id_table(i) IS NULL

Line 3798: FROM mtl_parameters

3794: IF l_org_id_table(i) IS NULL
3795: THEN
3796: SELECT organization_id
3797: INTO l_org_id_table(i)
3798: FROM mtl_parameters
3799: WHERE organization_code = l_org_code_table(i);
3800: END IF;
3801:
3802: IF l_comp_item_id_table(i) IS NULL

Line 4192: FROM mtl_parameters

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

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

4317: SYSDATE,
4318: 1,
4319: (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)),
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: );

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

4451: SYSDATE,
4452: 1,
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;

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

4516: SYSDATE,
4517: 1,
4518: (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)),
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: );

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

4638: SYSDATE,
4639: 1,
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;