Product: | PO - Purchasing |
---|---|
Description: | |
Implementation/DBA Data: | APPS.RCV_SUPPLIERS_VAL_V |
SELECT POV.VENDOR_NAME
, POV.SEGMENT1
, POV.NUM_1099
, POV.VAT_REGISTRATION_NUM
, POV.TYPE_1099
, POV.VENDOR_ID
, FL.MEANING HOLD_STATUS
, POV.TERMS_ID
, POV.SHIP_TO_LOCATION_ID
, POV.BILL_TO_LOCATION_ID
, POV.SHIP_VIA_LOOKUP_CODE
, POV.FOB_LOOKUP_CODE
, POV.FREIGHT_TERMS_LOOKUP_CODE
, POV.INVOICE_CURRENCY_CODE
, POV.HOLD_FLAG
, POV.RECEIPT_REQUIRED_FLAG
, POV.VAT_CODE
, POV.ALLOW_UNORDERED_RECEIPTS_FLAG
FROM FND_LOOKUPS FL
, PO_VENDORS POV
WHERE NVL(POV.HOLD_FLAG
, 'N') = FL.LOOKUP_CODE
AND FL.LOOKUP_TYPE = 'YES_NO'
AND POV.ENABLED_FLAG = 'Y'