[Home] [Help]
View: PO_SUPPLIERS_ALL_V
View Text
SELECT POV.VENDOR_NAME
, POV.SEGMENT1
, POV.TYPE_1099
, POV.NUM_1099
, POV.VAT_REGISTRATION_NUM
, POV.VENDOR_ID
, FL.MEANING
, POV.HOLD_FLAG
, POV.VAT_CODE
FROM PO_VENDORS POV
, FND_LOOKUPS FL
WHERE NVL(POV.HOLD_FLAG
, 'N') = FL.LOOKUP_CODE
AND FL.LOOKUP_TYPE = 'YES_NO'
Columns
Name |
VENDOR_NAME |
SEGMENT1 |
TYPE_1099 |
NUM_1099 |
VAT_REGISTRATION_NUM |
VENDOR_ID |
MEANING |
HOLD_FLAG |
VAT_CODE |