View: DPP_XLA_INV_CU_V

Product:	DPP - Oracle Price Protection
Description:	DPP SLA Execution Process View
Implementation/DBA Data:	APPS.DPP_XLA_INV_CU_V

View Text

SELECT DTH.TRANSACTION_NUMBER TRANSACTION_NUMBER
, APS.VENDOR_NAME
, APSS.VENDOR_SITE_CODE
, DED.CREATION_DATE TRANSACTION_DATE
, DTH.TRANSACTION_HEADER_ID
, DED.EXECUTION_DETAIL_ID
FROM DPP_TRANSACTION_HEADERS_ALL DTH
, DPP_EXECUTION_DETAILS DED
, DPP_XLA_HEADERS DXH
, AP_SUPPLIERS APS
, AP_SUPPLIER_SITES_ALL APSS
WHERE DED.TRANSACTION_HEADER_ID=DTH.TRANSACTION_HEADER_ID
AND DED.EXECUTION_DETAIL_ID=DXH.BASE_TRANSACTION_HEADER_ID
AND APS.VENDOR_ID=DTH.VENDOR_ID
AND APSS.VENDOR_SITE_ID=DTH.VENDOR_SITE_ID

Columns