[Home] [Help]
View: 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
Name |
RELEASE_NUM |
PO_RELEASE_ID |
RELEASE_DATE |
PO_HEADER_ID |
CONSIGNED_CONSUMPTION_FLAG |
ORG_ID |