APPS.MSC_X_VMI_POREQ dependencies on MTL_ITEM_REVISIONS

Line 359: mtl_item_revisions rev

355: SELECT max(rev.revision),
356: max(msi.revision_qty_control_code)
357: INTO var_revision,var_revision_ctrl
358: FROM mtl_system_items_b msi,
359: mtl_item_revisions rev
360: WHERE msi.inventory_item_id = ctemp.item_id
361: AND msi.organization_id = ctemp.destination_organization_id
362: AND rev.inventory_item_id = msi.inventory_item_id
363: AND rev.organization_id = msi.organization_id

Line 366: FROM mtl_item_revisions rev2

362: AND rev.inventory_item_id = msi.inventory_item_id
363: AND rev.organization_id = msi.organization_id
364: AND TRUNC(rev.effectivity_date) =
365: (SELECT TRUNC(max(rev2.effectivity_date))
366: FROM mtl_item_revisions rev2
367: WHERE rev2.implementation_date IS NOT NULL
368: AND rev2.effectivity_date <= TRUNC(SYSDATE)+.99999
369: AND rev2.organization_id = rev.organization_id
370: AND rev2.inventory_item_id = rev.inventory_item_id);