APPS.BOM_IMPORT_PUB dependencies on MTL_ITEM_REVISIONS

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

671: ELSIF p_effec_control = 4 THEN
672: BEGIN
673: SELECT BCB.component_sequence_id
674: INTO l_comp_seq_id
675: FROM bom_components_b BCB,bom_inventory_comps_interface BICI,Mtl_Item_Revisions MIR
676: WHERE BICI.batch_id = p_batch_id
677: AND (BICI.comp_source_system_reference = p_comp_rec_id OR BICI.component_item_number = p_comp_rec_id)
678: AND (BICI.process_flag = 1 or BICI.process_flag = 5 )
679: AND BCB.bill_sequence_id = p_bill_seq_id

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

780: ELSIF p_effec_control = 4 THEN
781: BEGIN
782: SELECT BCB.component_sequence_id
783: INTO l_comp_seq_id
784: FROM bom_components_b BCB,bom_inventory_comps_interface BICI,Mtl_Item_Revisions MIR
785: WHERE BICI.batch_id = p_batch_id
786: AND (BICI.comp_source_system_reference = p_comp_rec_id OR BICI.component_item_number = p_comp_rec_id)
787: AND (BICI.process_flag = 1 or BICI.process_flag = 5 )
788: AND BCB.bill_sequence_id = p_bill_seq_id

Line 3722: mtl_item_revisions_interface

3718: UNION ALL
3719: SELECT
3720: process_flag
3721: FROM
3722: mtl_item_revisions_interface
3723: WHERE
3724: set_process_id = p_batch_id
3725: AND process_flag = 1) ) QRSLT;
3726:

Line 4743: from mtl_item_revisions

4739:
4740: IF l_comp_table(j).parent_revision_code IS NOT NULL THEN
4741: SELECT effectivity_date
4742: INTO l_par_eff_date
4743: from mtl_item_revisions
4744: WHERE inventory_item_id = l_comp_table(j).assembly_item_id
4745: AND organization_id = l_comp_table(j).organization_id
4746: AND revision = l_comp_table(j).parent_revision_code;
4747: END IF;

Line 4942: from mtl_item_revisions

4938: l_comp_match_found := false;
4939: IF l_comp_table(k).parent_revision_code IS NOT NULL THEN
4940: SELECT effectivity_date
4941: INTO l_par_eff_date
4942: from mtl_item_revisions
4943: WHERE inventory_item_id = l_comp_table(k).assembly_item_id
4944: AND organization_id = l_comp_table(k).organization_id
4945: AND revision = l_comp_table(k).parent_revision_code;
4946: END IF;

Line 5813: FROM mtl_item_revisions_b mrb

5809:
5810: IF l_header_table(i).revision IS NOT NULL THEN
5811: SELECT mrb.revision_id
5812: INTO l_rev_id
5813: FROM mtl_item_revisions_b mrb
5814: WHERE mrb.inventory_item_id = l_header_table(i).assembly_item_id
5815: AND mrb.organization_id = l_header_table(i).organization_id
5816: AND mrb.revision = l_header_table(i).revision;
5817: END IF;