VIEW: APPS.CLN_PO_CHANGE_RESPONSE_LINE_V

Source

View Text - Preformatted

SELECT document_line_id , max(decode(request_level , 'LINE',request_status,null)) request_status , min(request_status) min_request_status , max(decode(request_level , 'LINE',response_reason,null)) response_reason, max(supplier_line_ref) FROM po_change_requests WHERE change_request_group_id = (SELECT CLN_PO_CHANGE_RESPONSE_PKG.Get_change_request_group_id() FROM DUAL) AND (request_level = 'LINE' or request_level = 'SHIPMENT') GROUP by document_line_id

View Text - HTML Formatted

SELECT DOCUMENT_LINE_ID
, MAX(DECODE(REQUEST_LEVEL
, 'LINE'
, REQUEST_STATUS
, NULL)) REQUEST_STATUS
, MIN(REQUEST_STATUS) MIN_REQUEST_STATUS
, MAX(DECODE(REQUEST_LEVEL
, 'LINE'
, RESPONSE_REASON
, NULL)) RESPONSE_REASON
, MAX(SUPPLIER_LINE_REF)
FROM PO_CHANGE_REQUESTS
WHERE CHANGE_REQUEST_GROUP_ID = (SELECT CLN_PO_CHANGE_RESPONSE_PKG.GET_CHANGE_REQUEST_GROUP_ID()
FROM DUAL)
AND (REQUEST_LEVEL = 'LINE' OR REQUEST_LEVEL = 'SHIPMENT') GROUP BY DOCUMENT_LINE_ID