APPS.BOMPCMBM dependencies on MTL_ITEM_REVISIONS_B

Line 4495: FROM MTL_ITEM_REVISIONS_B source, MTL_ITEM_REVISIONS_B dest

4491: IF l_comp_count > 0
4492: THEN
4493: SELECT count(*)
4494: INTO l_rev_count
4495: FROM MTL_ITEM_REVISIONS_B source, MTL_ITEM_REVISIONS_B dest
4496: WHERE source.inventory_item_id = dest.inventory_item_id
4497: AND source.revision_id IN (SELECT COMPONENT_ITEM_REVISION_ID
4498: FROM BOM_COMPONENTS_B
4499: WHERE BILL_SEQUENCE_ID = p_src_bill_seq_id)

Line 4526: FROM MTL_ITEM_REVISIONS_B src, MTL_ITEM_REVISIONS_B dest

4522: l_rev_id NUMBER;
4523: BEGIN
4524: SELECT dest.revision_id
4525: INTO l_rev_id
4526: FROM MTL_ITEM_REVISIONS_B src, MTL_ITEM_REVISIONS_B dest
4527: WHERE dest.inventory_item_id = src.inventory_item_id
4528: AND dest.organization_id = p_org_id
4529: AND dest.revision = src.revision
4530: AND src.revision_id = p_rev_id;