[Home] [Help]
View: PO_SUPPLIER_OPEN_POS_V
View Text
SELECT DISTINCT POV.VENDOR_ID
, POV.VENDOR_NAME
, POV.SEGMENT1
, POV.NUM_1099
, POV.VAT_REGISTRATION_NUM
, POV.TYPE_1099
, FL.MEANING
, PH.ORG_ID
FROM PO_VENDORS POV
, PO_HEADERS PH
, FND_LOOKUPS FL
WHERE NVL(POV.HOLD_FLAG
, 'N') = FL.LOOKUP_CODE
AND FL.LOOKUP_TYPE = 'YES_NO'
AND NVL(PH.CLOSED_CODE
, 'OPEN') = 'OPEN'
AND POV.VENDOR_ID = PH.VENDOR_ID
AND NVL(PH.CANCEL_FLAG
, 'N') = 'N'
Columns
Name |
VENDOR_ID |
VENDOR_NAME |
SEGMENT1 |
NUM_1099 |
VAT_REGISTRATION_NUM |
TYPE_1099 |
MEANING |
ORG_ID |