View: CLN_PO_CHANGE_RESPONSE_LINE_V

Product:	CLN - Supply Chain Trading Connector for RosettaNet
Description:	This view is used for mapping purposes in PIP-3A8Response
Implementation/DBA Data:	APPS.CLN_PO_CHANGE_RESPONSE_LINE_V

View Text

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

Columns