VIEW: APPS.AP_DUPLICATE_VENDORS_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)