Product: | CSP - Spares Management |
---|---|
Description: | Picklist line information |
Implementation/DBA Data: | APPS.CSP_PICKLIST_LINES_V1 |
SELECT CPIL.ROWID
, CPIH.PICKLIST_NUMBER
, CPIH.PICKLIST_HEADER_ID
, MSIV.CONCATENATED_SEGMENTS
, CPIL.INVENTORY_ITEM_ID
, MSIV.DESCRIPTION
, CPIL.REVISION
, MTRH.REQUEST_NUMBER
, MTRH.HEADER_ID
, MTRL.LINE_NUMBER
, MTRL.LINE_ID
, MTRL.ORGANIZATION_ID
, CPIL.QUANTITY_PICKED - CSP_PACKLIST_PVT.PACKED_QUANTITY(CPIL.PICKLIST_LINE_ID)
, CPIL.PICKLIST_LINE_NUMBER
, CPIL.PICKLIST_LINE_ID
, CPIL.UOM_CODE
, CIA.INCIDENT_NUMBER
, MTRL.DATE_REQUIRED
, CMH.LOCATION_ID
, CMH.PARTY_SITE_ID
, CSI.SECONDARY_INVENTORY_NAME
, CMH.CARRIER
, CMH.SHIPMENT_METHOD FROM MTL_SYSTEM_ITEMS_VL MSIV
, CSP_PICKLIST_LINES CPIL
, MTL_TXN_REQUEST_HEADERS MTRH
, MTL_TXN_REQUEST_LINES MTRL
, CSP_PICKLIST_HEADERS CPIH
, CSP_SEC_INVENTORIES CSI
, CSP_MOVEORDER_LINES CML
, CSP_MOVEORDER_HEADERS CMH
, CS_INCIDENTS_ALL CIA
WHERE MSIV.ORGANIZATION_ID = MTRL.ORGANIZATION_ID
AND MSIV.INVENTORY_ITEM_ID = CPIL.INVENTORY_ITEM_ID
AND CPIH.PICKLIST_HEADER_ID = CPIL.PICKLIST_HEADER_ID
AND MTRL.LINE_ID = CPIL.LINE_ID
AND MTRL.LINE_STATUS IN (3
, 7)
AND MTRH.HEADER_ID = MTRL.HEADER_ID
AND CPIH.PICKLIST_STATUS = 3
AND CPIL.QUANTITY_PICKED - CSP_PACKLIST_PVT.PACKED_QUANTITY(CPIL.PICKLIST_LINE_ID) > 0
AND CSI.ORGANIZATION_ID = MTRL.ORGANIZATION_ID
AND CSI.SECONDARY_INVENTORY_NAME = MTRL.TO_SUBINVENTORY_CODE
AND CML.LINE_ID = MTRL.LINE_ID
AND CMH.HEADER_ID = MTRH.HEADER_ID
AND CIA.INCIDENT_ID(+) = CML.INCIDENT_ID