VIEW: APPS.CSP_PICK_CONFIRM_V

Source

View Text - Preformatted

SELECT cph.picklist_header_id, mtrl.line_number, msibk.concatenated_segments, msibk.description, mmtt.revision, mmtt.subinventory_code, milk1.concatenated_segments, mmtt.transaction_quantity, mmtt.transaction_uom, mmtt.transfer_subinventory, milk2.concatenated_segments, mmtt.last_updated_by, mmtt.last_update_date, mmtt.creation_date, mmtt.created_by, mmtt.last_update_login from mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl, csp_picklist_headers cph, mtl_system_items_b_kfv msibk, mtl_item_locations_kfv milk1, mtl_item_locations_kfv milk2 where mmtt.trx_source_line_id = mtrl.line_id and mmtt.inventory_item_id = msibk.inventory_item_id and mmtt.organization_id = msibk.organization_id and milk1.inventory_location_id(+) = mmtt.locator_id and milk2.inventory_location_id(+) = mmtt.transfer_to_location and mmtt.trx_source_line_id in (select distinct cpl.line_id from csp_picklist_lines cpl where cpl.picklist_header_id = cph.picklist_header_id)

View Text - HTML Formatted

SELECT CPH.PICKLIST_HEADER_ID
, MTRL.LINE_NUMBER
, MSIBK.CONCATENATED_SEGMENTS
, MSIBK.DESCRIPTION
, MMTT.REVISION
, MMTT.SUBINVENTORY_CODE
, MILK1.CONCATENATED_SEGMENTS
, MMTT.TRANSACTION_QUANTITY
, MMTT.TRANSACTION_UOM
, MMTT.TRANSFER_SUBINVENTORY
, MILK2.CONCATENATED_SEGMENTS
, MMTT.LAST_UPDATED_BY
, MMTT.LAST_UPDATE_DATE
, MMTT.CREATION_DATE
, MMTT.CREATED_BY
, MMTT.LAST_UPDATE_LOGIN
FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
, MTL_TXN_REQUEST_LINES MTRL
, CSP_PICKLIST_HEADERS CPH
, MTL_SYSTEM_ITEMS_B_KFV MSIBK
, MTL_ITEM_LOCATIONS_KFV MILK1
, MTL_ITEM_LOCATIONS_KFV MILK2
WHERE MMTT.TRX_SOURCE_LINE_ID = MTRL.LINE_ID
AND MMTT.INVENTORY_ITEM_ID = MSIBK.INVENTORY_ITEM_ID
AND MMTT.ORGANIZATION_ID = MSIBK.ORGANIZATION_ID
AND MILK1.INVENTORY_LOCATION_ID(+) = MMTT.LOCATOR_ID
AND MILK2.INVENTORY_LOCATION_ID(+) = MMTT.TRANSFER_TO_LOCATION
AND MMTT.TRX_SOURCE_LINE_ID IN (SELECT DISTINCT CPL.LINE_ID
FROM CSP_PICKLIST_LINES CPL
WHERE CPL.PICKLIST_HEADER_ID = CPH.PICKLIST_HEADER_ID)