DBA Data[Home] [Help]

APPS.MRP_AP_REL_PLAN_PUB dependencies on MTL_ITEM_REVISIONS

Line 2735: mtl_item_revisions rev

2731: SELECT max(rev.revision),
2732: max(msi.revision_qty_control_code)
2733: INTO var_revision,var_revision_ctrl
2734: FROM mtl_system_items_b msi,
2735: mtl_item_revisions rev
2736: WHERE msi.inventory_item_id = ctemp.item_id
2737: AND msi.organization_id = ctemp.destination_organization_id
2738: AND rev.inventory_item_id = msi.inventory_item_id
2739: AND rev.organization_id = msi.organization_id

Line 2742: FROM mtl_item_revisions rev2

2738: AND rev.inventory_item_id = msi.inventory_item_id
2739: AND rev.organization_id = msi.organization_id
2740: AND TRUNC(rev.effectivity_date) =
2741: (SELECT TRUNC(max(rev2.effectivity_date))
2742: FROM mtl_item_revisions rev2
2743: WHERE rev2.implementation_date IS NOT NULL
2744: AND rev2.effectivity_date <= TRUNC(SYSDATE)+.99999
2745: AND rev2.organization_id = rev.organization_id
2746: AND rev2.inventory_item_id = rev.inventory_item_id);