DBA Data[Home] [Help]

APPS.WMS_PICK_DROP_PVT dependencies on MTL_ITEM_REVISIONS

Line 10626: , mtl_item_revisions mir

10622: SELECT mcr.inventory_item_id
10623: , mcr.uom_code
10624: , mir.revision
10625: FROM mtl_cross_references mcr
10626: , mtl_item_revisions mir
10627: WHERE mcr.organization_id = mir.organization_id (+)
10628: AND mcr.inventory_item_id = mir.inventory_item_id (+)
10629: AND mcr.revision_id = mir.revision_id (+)
10630: AND mcr.cross_reference_type = p_ref_type