VIEW: APPS.AP_AWT_BUCKETS_V

Source

View Text - Preformatted

SELECT V.VENDOR_NAME VENDOR_NAME , V.SEGMENT1 SEGMENT1 , AB.PERIOD_NAME PERIOD_NAME , AB.TAX_NAME TAX_NAME , AB.VENDOR_ID VENDOR_ID , AB.WITHHELD_AMOUNT_TO_DATE WITHHELD_AMOUNT_TO_DATE , AB.GROSS_AMOUNT_TO_DATE GROSS_AMOUNT_TO_DATE , AB.LAST_UPDATE_DATE LAST_UPDATE_DATE , AB.LAST_UPDATED_BY LAST_UPDATED_BY , AB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , AB.CREATION_DATE CREATION_DATE , AB.CREATED_BY CREATED_BY , AB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE , AB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID , AB.PROGRAM_ID PROGRAM_ID , AB.REQUEST_ID REQUEST_ID , AB.ORG_ID ORG_ID FROM PO_VENDORS V, AP_AWT_BUCKETS AB WHERE V.VENDOR_ID = AB.VENDOR_ID

View Text - HTML Formatted

SELECT V.VENDOR_NAME VENDOR_NAME
, V.SEGMENT1 SEGMENT1
, AB.PERIOD_NAME PERIOD_NAME
, AB.TAX_NAME TAX_NAME
, AB.VENDOR_ID VENDOR_ID
, AB.WITHHELD_AMOUNT_TO_DATE WITHHELD_AMOUNT_TO_DATE
, AB.GROSS_AMOUNT_TO_DATE GROSS_AMOUNT_TO_DATE
, AB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AB.LAST_UPDATED_BY LAST_UPDATED_BY
, AB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AB.CREATION_DATE CREATION_DATE
, AB.CREATED_BY CREATED_BY
, AB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, AB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, AB.PROGRAM_ID PROGRAM_ID
, AB.REQUEST_ID REQUEST_ID
, AB.ORG_ID ORG_ID
FROM PO_VENDORS V
, AP_AWT_BUCKETS AB
WHERE V.VENDOR_ID = AB.VENDOR_ID