VIEW: APPS.CSP_PICKLIST_LINES_V1

Source

View Text - Preformatted

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

View Text - HTML Formatted

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