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_ALL_V

Product:	PO - Purchasing
Description:	10SC ONLY - Retrofitted
Implementation/DBA Data:	APPS.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