View: AP_DUPLICATE_VENDORS_V

Product:	AP - Payables
Description:	(Release 10SC Only)
Implementation/DBA Data:	APPS.AP_DUPLICATE_VENDORS_V

View Text

SELECT ADV.ROWID ROW_ID
, ADV.AMOUNT_PAID_INVOICES AMOUNT_PAID_INVOICES
, ADV.AMOUNT_UNPAID_INVOICES AMOUNT_UNPAID_INVOICES
, ADV.CREATED_BY CREATED_BY
, ADV.CREATION_DATE CREATION_DATE
, ADV.DUPLICATE_VENDOR_ID DUPLICATE_VENDOR_ID
, ADV.DUPLICATE_VENDOR_SITE_ID DUPLICATE_VENDOR_SITE_ID
, ADV.ENTRY_ID ENTRY_ID
, ADV.KEEP_SITE_FLAG KEEP_SITE_FLAG
, ADV.LAST_UPDATED_BY LAST_UPDATED_BY
, ADV.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ADV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ADV.NUMBER_PAID_INVOICES NUMBER_PAID_INVOICES
, ADV.NUMBER_PO_HEADERS_CHANGED NUMBER_PO_HEADERS_CHANGED
, ADV.NUMBER_UNPAID_INVOICES NUMBER_UNPAID_INVOICES
, ADV.PAID_INVOICES_FLAG PAID_INVOICES_FLAG
, ADV.PROCESS PROCESS
, ADV.PROCESS_FLAG PROCESS_FLAG
, ADV.VENDOR_ID VENDOR_ID
, ADV.VENDOR_SITE_ID VENDOR_SITE_ID
, PV.VENDOR_NAME DUP_VENDOR_NAME
, PVS.VENDOR_SITE_CODE DUP_VENDOR_SITE_CODE
, PV1.VENDOR_NAME VENDOR_NAME
, PVS1.VENDOR_SITE_CODE VENDOR_SITE_CODE
, DECODE(ADV.PROCESS
, 'P'
, 'P'
, DECODE(ADV.PAID_INVOICES_FLAG
, 'Y'
, 'B'
, 'I')) PROCESS_INVOICE
, DECODE(ADV.PROCESS
, 'I'
, 'N'
, 'Y') PO_CHECK_BOX
, ADV.ORG_ID
FROM AP_DUPLICATE_VENDORS ADV
, PO_VENDORS PV
, PO_VENDOR_SITES PVS
, PO_VENDORS PV1
, PO_VENDOR_SITES PVS1
WHERE ADV.DUPLICATE_VENDOR_ID = PV.VENDOR_ID(+)
AND ADV.DUPLICATE_VENDOR_SITE_ID = PVS.VENDOR_SITE_ID(+)
AND ADV.VENDOR_ID = PV1.VENDOR_ID(+)
AND ADV.VENDOR_SITE_ID = PVS1.VENDOR_SITE_ID(+)

Columns