View: XTR_RECONCILIATION_HEADERS_V

Product:	XTR - Treasury
Description:
Implementation/DBA Data:	APPS.XTR_RECONCILIATION_HEADERS_V

View Text

SELECT DISTINCT TR.SOURCE
, PR.VALUE_DATE
, TR.ACCOUNT_NUMBER
, TR.CURRENCY FROM XTR_AVAILABLE_FOR_RECON_V AV
, XTR_IMPORT_TRAILER_DETAILS_V TR
, XTR_PAY_REC_RECONCILIATION_V PR WHERE AV.IMPORT_REFERENCE = TR.IMPORT_REFERENCE (+) AND AV.IMPORT_REFERENCE = PR.IMPORT_REFERENCE (+) AND TR.IMPORT_REFERENCE = PR.IMPORT_REFERENCE

Columns