VIEW: APPS.ISCBV_BOOKINGS_BASE_FCV

Source

View Text - Preformatted

SELECT txn_source_line_id LINE_ID, max(pick_slip_date) DATE_LATEST_PICK FROM mtl_txn_request_lines WHERE (transaction_type_id = 52 OR transaction_type_id = 53) AND (transaction_source_type_id = 2 OR transaction_source_type_id = 8) GROUP BY txn_source_line_id

View Text - HTML Formatted

SELECT TXN_SOURCE_LINE_ID LINE_ID
, MAX(PICK_SLIP_DATE) DATE_LATEST_PICK
FROM MTL_TXN_REQUEST_LINES
WHERE (TRANSACTION_TYPE_ID = 52 OR TRANSACTION_TYPE_ID = 53)
AND (TRANSACTION_SOURCE_TYPE_ID = 2 OR TRANSACTION_SOURCE_TYPE_ID = 8) GROUP BY TXN_SOURCE_LINE_ID