DBA Data[Home] [Help]

APPS.CSP_EXCESS_PARTS_PVT dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 205: from mtl_onhand_quantities_detail moq,

201: cursor c_org_items is
202: select distinct moq.inventory_item_id,
203: nvl(msib.max_minmax_quantity,0) max,
204: revision_qty_control_code
205: from mtl_onhand_quantities_detail moq,
206: mtl_system_items_b msib
207: where moq.organization_id = p_organization_id
208: and msib.organization_id = moq.organization_id
209: and msib.inventory_item_id = moq.inventory_item_id