View: PO_VENDORS_ACTIVE_AP_V

Product:	AP - Payables
Description:
Implementation/DBA Data:	APPS.PO_VENDORS_ACTIVE_AP_V

View Text

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'

Columns