DBA Data[Home] [Help]

APPS.CSP_PART_SEARCH_PVT dependencies on MTL_ONHAND_QUANTITIES

Line 490: from mtl_onhand_quantities moq,

486: or nvl(csi.secondary_inventory_name,'-1') <> l_subinventory_code)
487: and csi.condition_type = 'G'
488: and exists
489: (select 'x'
490: from mtl_onhand_quantities moq,
491: csp_required_parts_temp crpt
492: where moq.organization_id = csi.organization_id
493: and moq.subinventory_code = csi.secondary_inventory_name
494: and moq.inventory_item_id = crpt.alternate_item_id);

Line 759: from mtl_onhand_quantities moq

755: and (cpp.organization_id <> nvl(l_organization_id, -999)
756: or nvl(cpp.secondary_inventory,'-1') <> l_subinventory_code)
757: and cocv.calendar_id(+) = cpp.calendar_id
758: and exists (select 'x'
759: from mtl_onhand_quantities moq
760: where moq.organization_id = cpp.organization_id
761: and moq.subinventory_code = nvl(cpp.secondary_inventory,
762: moq.subinventory_code)
763: and moq.inventory_item_id = crpt.alternate_item_id)