DBA Data[Home] [Help]

APPS.MSC_X_VMI_POREQ dependencies on MTL_SYSTEM_ITEMS_B

Line 358: FROM mtl_system_items_b msi,

354: BEGIN
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