APPS.BOM_IMPORT_PUB dependencies on MTL_ITEM_REVISIONS

Line 668: FROM bom_components_b BCB,bom_inventory_comps_interface BICI,Mtl_Item_Revisions MIR

664: ELSIF p_effec_control = 4 THEN
665: BEGIN
666: SELECT BCB.component_sequence_id
667: INTO l_comp_seq_id
668: FROM bom_components_b BCB,bom_inventory_comps_interface BICI,Mtl_Item_Revisions MIR
669: WHERE BICI.batch_id = p_batch_id
670: AND (BICI.comp_source_system_reference = p_comp_rec_id OR BICI.component_item_number = p_comp_rec_id)
671: AND (BICI.process_flag = 1 or BICI.process_flag = 5 )
672: AND BCB.bill_sequence_id = p_bill_seq_id

Line 3330: mtl_item_revisions_interface

3326: UNION ALL
3327: SELECT
3328: process_flag
3329: FROM
3330: mtl_item_revisions_interface
3331: WHERE
3332: set_process_id = p_batch_id
3333: AND process_flag = 1) ) QRSLT;
3334:

Line 4351: from mtl_item_revisions

4347:
4348: IF l_comp_table(j).parent_revision_code IS NOT NULL THEN
4349: SELECT effectivity_date
4350: INTO l_par_eff_date
4351: from mtl_item_revisions
4352: WHERE inventory_item_id = l_comp_table(j).assembly_item_id
4353: AND organization_id = l_comp_table(j).organization_id
4354: AND revision = l_comp_table(j).parent_revision_code;
4355: END IF;

Line 4550: from mtl_item_revisions

4546: l_comp_match_found := false;
4547: IF l_comp_table(k).parent_revision_code IS NOT NULL THEN
4548: SELECT effectivity_date
4549: INTO l_par_eff_date
4550: from mtl_item_revisions
4551: WHERE inventory_item_id = l_comp_table(k).assembly_item_id
4552: AND organization_id = l_comp_table(k).organization_id
4553: AND revision = l_comp_table(k).parent_revision_code;
4554: END IF;

Line 5421: FROM mtl_item_revisions_b mrb

5417:
5418: IF l_header_table(i).revision IS NOT NULL THEN
5419: SELECT mrb.revision_id
5420: INTO l_rev_id
5421: FROM mtl_item_revisions_b mrb
5422: WHERE mrb.inventory_item_id = l_header_table(i).assembly_item_id
5423: AND mrb.organization_id = l_header_table(i).organization_id
5424: AND mrb.revision = l_header_table(i).revision;
5425: END IF;