DBA Data[Home] [Help]

APPS.MRP_AP_REL_PLAN_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 3021: FROM mtl_system_items_b msi,

3017: BEGIN
3018: SELECT max(rev.revision),
3019: max(msi.revision_qty_control_code)
3020: INTO var_revision,var_revision_ctrl
3021: FROM mtl_system_items_b msi,
3022: mtl_item_revisions rev
3023: WHERE msi.inventory_item_id = ctemp.item_id
3024: AND msi.organization_id = ctemp.destination_organization_id
3025: AND rev.inventory_item_id = msi.inventory_item_id