[Home] [Help]
View: PO_CONTRACTS_VAL_V
View Text
SELECT PH.SEGMENT1
, PH.PO_HEADER_ID
, PV.VENDOR_ID
, PV.VENDOR_NAME
, PH.START_DATE
, PH.END_DATE
, PH.ORG_ID
FROM PO_HEADERS PH
, PO_VENDORS PV
WHERE PH.VENDOR_ID = PV.VENDOR_ID
AND PH.TYPE_LOOKUP_CODE = 'CONTRACT'
AND NVL(PH.CANCEL_FLAG
, 'N') = 'N'
AND SYSDATE BETWEEN NVL(PH.START_DATE
, SYSDATE - 1)
AND NVL(PH.END_DATE
, SYSDATE + 1)
Columns
Name |
SEGMENT1 |
PO_HEADER_ID |
VENDOR_ID |
VENDOR_NAME |
START_DATE |
END_DATE |
ORG_ID |