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.

VIEW: APPS.PO_VENDORS_ACTIVE_AP_V

Source

View Text - Preformatted


SELECT VENDOR_NAME VENDOR_NAME , VENDOR_ID VENDOR_ID , SEGMENT1 VENDOR_NUMBER , VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE_LOOKUP_CODE , DECODE(FEDERAL_REPORTABLE_FLAG, 'Y',TYPE_1099, '') TYPE_1099 , EMPLOYEE_ID EMPLOYEE_ID , V.NUM_1099 NUM_1099 , V.VAT_REGISTRATION_NUM VAT_REGISTRATION_NUM , V.AWT_GROUP_ID AWT_GROUP_ID , V.ALLOW_AWT_FLAG ALLOW_AWT_FLAG , V.HOLD_ALL_PAYMENTS_FLAG HOLD_ALL_PAYMENTS_FLAG , V.PARTY_ID FROM PO_VENDORS V WHERE SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE - 1) AND NVL(END_DATE_ACTIVE, SYSDATE + 1) AND ENABLED_FLAG = 'Y'

View Text - HTML Formatted

SELECT VENDOR_NAME VENDOR_NAME
, VENDOR_ID VENDOR_ID
, SEGMENT1 VENDOR_NUMBER
, VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE_LOOKUP_CODE
, DECODE(FEDERAL_REPORTABLE_FLAG
, 'Y'
, TYPE_1099
, '') TYPE_1099
, EMPLOYEE_ID EMPLOYEE_ID
, V.NUM_1099 NUM_1099
, V.VAT_REGISTRATION_NUM VAT_REGISTRATION_NUM
, V.AWT_GROUP_ID AWT_GROUP_ID
, V.ALLOW_AWT_FLAG ALLOW_AWT_FLAG
, V.HOLD_ALL_PAYMENTS_FLAG HOLD_ALL_PAYMENTS_FLAG
, V.PARTY_ID
FROM PO_VENDORS V
WHERE SYSDATE BETWEEN NVL(START_DATE_ACTIVE
, SYSDATE - 1)
AND NVL(END_DATE_ACTIVE
, SYSDATE + 1)
AND ENABLED_FLAG = 'Y'