eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PO_SUPPLIERS_VAL_V

Product:	PO - Purchasing
Description:	10SC ONLY - Retrofitted
Implementation/DBA Data:	APPS.PO_SUPPLIERS_VAL_V

View Text

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
, NVL(POV.HOLD_FLAG
, 'N')
, 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'
AND SYSDATE BETWEEN NVL(POV.START_DATE_ACTIVE
, SYSDATE-1)
AND NVL(POV.END_DATE_ACTIVE
, SYSDATE+1)

Columns

Name
VENDOR_NAME
SEGMENT1
NUM_1099
VAT_REGISTRATION_NUM
TYPE_1099
VENDOR_ID
HOLD_STATUS
TERMS_ID
SHIP_TO_LOCATION_ID
BILL_TO_LOCATION_ID
SHIP_VIA_LOOKUP_CODE
FOB_LOOKUP_CODE
FREIGHT_TERMS_LOOKUP_CODE
INVOICE_CURRENCY_CODE
HOLD_FLAG
RECEIPT_REQUIRED_FLAG
VAT_CODE
ALLOW_UNORDERED_RECEIPTS_FLAG