[Home] [Help]
View: 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
Name |
SOURCE |
VALUE_DATE |
ACCOUNT_NUMBER |
CURRENCY |