APPS.BOMPCMBM dependencies on MTL_ITEM_REVISIONS_B

Line 4843: FROM MTL_ITEM_REVISIONS_B source, MTL_ITEM_REVISIONS_B dest

4839: IF l_comp_count > 0
4840: THEN
4841: SELECT count(*)
4842: INTO l_rev_count
4843: FROM MTL_ITEM_REVISIONS_B source, MTL_ITEM_REVISIONS_B dest
4844: WHERE source.inventory_item_id = dest.inventory_item_id
4845: AND source.revision_id IN (SELECT COMPONENT_ITEM_REVISION_ID
4846: FROM BOM_COMPONENTS_B
4847: WHERE BILL_SEQUENCE_ID = p_src_bill_seq_id)

Line 4874: FROM MTL_ITEM_REVISIONS_B src, MTL_ITEM_REVISIONS_B dest

4870: l_rev_id NUMBER;
4871: BEGIN
4872: SELECT dest.revision_id
4873: INTO l_rev_id
4874: FROM MTL_ITEM_REVISIONS_B src, MTL_ITEM_REVISIONS_B dest
4875: WHERE dest.inventory_item_id = src.inventory_item_id
4876: AND dest.organization_id = p_org_id
4877: AND dest.revision = src.revision
4878: AND src.revision_id = p_rev_id;