View: PO_RELEASES_VAL_V

Product:	PO - Purchasing
Description:	10SC ONLY - Retrofitted
Implementation/DBA Data:	APPS.PO_RELEASES_VAL_V

View Text

SELECT DISTINCT PR.RELEASE_NUM
, PR.PO_RELEASE_ID
, PR.RELEASE_DATE
, PR.PO_HEADER_ID
, PR.CONSIGNED_CONSUMPTION_FLAG
, PR.ORG_ID
FROM PO_RELEASES PR
WHERE NVL(PR.CANCEL_FLAG
, 'N') = 'N'
AND NVL(PR.APPROVED_FLAG
, 'N') != 'N'
AND NVL(PR.CLOSED_CODE
, 'OPEN') != 'FINALLY CLOSED'

Columns