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'
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'
|
|
|