View: XTR_RECONCILIATION_MATRIX_V

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

View Text

SELECT A.VERIFY_METHOD VERIFICATION_METHOD
, A.PASS_CODE RECONCILIATION_PASS_CODE
, A.VER_SEQ SEQUENCE_ORDER
, DECODE(A.PASS_COL
, D.AMOUNT_CODE
, DECODE(A.CROSS
, D.MATCH_CODE
, D.MATCH_MEANING
, SUMDATE_CODE
, SUMDATE_MEANING
, SUMRANGE_CODE
, SUMRANGE_MEANING
, A.CROSS)
, NULL) AMOUNT_RECON_DETAIL
, DECODE(A.PASS_COL
, D.BANK_ACCT_CODE
, DECODE(A.CROSS
, D.MATCH_CODE
, D.MATCH_MEANING
, SUMDATE_CODE
, SUMDATE_MEANING
, SUMRANGE_CODE
, SUMRANGE_MEANING
, A.CROSS)
, NULL) BANK_ACCT_RECON_DETAIL
, DECODE(A.PASS_COL
, D.DATE_CODE
, DECODE(A.CROSS
, D.MATCH_CODE
, D.MATCH_MEANING
, SUMDATE_CODE
, SUMDATE_MEANING
, SUMRANGE_CODE
, SUMRANGE_MEANING
, A.CROSS)
, NULL) DATE_RECON_DETAIL
, DECODE(A.PASS_COL
, D.DEAL_NUM_CODE
, DECODE(A.CROSS
, D.MATCH_CODE
, D.MATCH_MEANING
, SUMDATE_CODE
, SUMDATE_MEANING
, SUMRANGE_CODE
, SUMRANGE_MEANING
, A.CROSS)
, NULL) DEAL_NUM_RECON_DETAIL
, DECODE(A.PASS_COL
, D.DEAL_TYPE_CODE
, DECODE(A.CROSS
, D.MATCH_CODE
, D.MATCH_MEANING
, SUMDATE_CODE
, SUMDATE_MEANING
, SUMRANGE_CODE
, SUMRANGE_MEANING
, A.CROSS)
, NULL) DEAL_TYPE_RECON_DETAIL
, DECODE(A.PASS_COL
, D.PARTY_CODE
, DECODE(A.CROSS
, D.MATCH_CODE
, D.MATCH_MEANING
, SUMDATE_CODE
, SUMDATE_MEANING
, SUMRANGE_CODE
, SUMRANGE_MEANING
, A.CROSS)
, NULL) PARTY_RECON_DETAIL
, DECODE(A.PASS_COL
, D.PORTFOLIO_CODE
, DECODE(A.CROSS
, D.MATCH_CODE
, D.MATCH_MEANING
, SUMDATE_CODE
, SUMDATE_MEANING
, SUMRANGE_CODE
, SUMRANGE_MEANING
, A.CROSS)
, NULL) PORTFOLIO_RECON_DETAIL
, DECODE(A.PASS_COL
, D.PRODUCT_CODE
, DECODE(A.CROSS
, D.MATCH_CODE
, D.MATCH_MEANING
, SUMDATE_CODE
, SUMDATE_MEANING
, SUMRANGE_CODE
, SUMRANGE_MEANING
, A.CROSS)
, NULL) PRODUCT_RECON_DETAIL
, DECODE(A.PASS_COL
, D.SERIAL_NUM_CODE
, DECODE(A.CROSS
, D.MATCH_CODE
, D.MATCH_MEANING
, SUMDATE_CODE
, SUMDATE_MEANING
, SUMRANGE_CODE
, SUMRANGE_MEANING
, A.CROSS)
, NULL) SERIAL_NUM_RECON_DETAIL
, DECODE(A.PASS_COL
, D.SUBTYPE_CODE
, DECODE(A.CROSS
, D.MATCH_CODE
, D.MATCH_MEANING
, SUMDATE_CODE
, SUMDATE_MEANING
, SUMRANGE_CODE
, SUMRANGE_MEANING
, A.CROSS)
, NULL) SUBTYPE_RECON_DETAIL
FROM ( SELECT A.VERIFICATION_METHOD VERIFY_METHOD
, A.SEQUENCE_ORDER VER_SEQ
, A.RECONCILED_PASS_CODE PASS_CODE
, B.RECONCILE_ON_COLUMN PASS_COL
, DECODE(B.RECONCILE_ON_COLUMN
, C.LOOKUP_CODE
, B.RECONCILE_DETAIL
, NULL) CROSS FROM XTR_RECONCILIATION_PROCESS_V A
, XTR_RECONCILIATION_PASSES_V B
, FND_LOOKUPS C
WHERE A.RECONCILED_PASS_CODE = B.RECONCILED_PASS_CODE AND C.LOOKUP_TYPE = 'XTR_RECON_ON_COLUMN' AND DECODE(B.RECONCILE_ON_COLUMN
, C.LOOKUP_CODE
, B.RECONCILE_DETAIL
, NULL) IS NOT NULL ) A
, ( SELECT MAX(DECODE(LOOKUP_CODE
, 'AMOUNT'
, LOOKUP_CODE)) AMOUNT_CODE
, MAX(DECODE(LOOKUP_CODE
, 'AMOUNT'
, MEANING)) AMOUNT_MEANING
, MAX(DECODE(LOOKUP_CODE
, 'BANK ACCT'
, LOOKUP_CODE)) BANK_ACCT_CODE
, MAX(DECODE(LOOKUP_CODE
, 'BANK ACCT'
, MEANING)) BANK_ACCT_MEANING
, MAX(DECODE(LOOKUP_CODE
, 'DATE'
, LOOKUP_CODE)) DATE_CODE
, MAX(DECODE(LOOKUP_CODE
, 'DATE'
, MEANING)) DATE_MEANING
, MAX(DECODE(LOOKUP_CODE
, 'DEAL NUM'
, LOOKUP_CODE)) DEAL_NUM_CODE
, MAX(DECODE(LOOKUP_CODE
, 'DEAL NUM'
, MEANING)) DEAL_NUM_MEANING
, MAX(DECODE(LOOKUP_CODE
, 'DEAL TYPE'
, LOOKUP_CODE)) DEAL_TYPE_CODE
, MAX(DECODE(LOOKUP_CODE
, 'DEAL TYPE'
, MEANING)) DEAL_TYPE_MEANING
, MAX(DECODE(LOOKUP_CODE
, 'PARTY'
, LOOKUP_CODE)) PARTY_CODE
, MAX(DECODE(LOOKUP_CODE
, 'PARTY'
, MEANING)) PARTY_MEANING
, MAX(DECODE(LOOKUP_CODE
, 'PORTFOLIO'
, LOOKUP_CODE)) PORTFOLIO_CODE
, MAX(DECODE(LOOKUP_CODE
, 'PORTFOLIO'
, MEANING)) PORTFOLIO_MEANING
, MAX(DECODE(LOOKUP_CODE
, 'PRODUCT'
, LOOKUP_CODE)) PRODUCT_CODE
, MAX(DECODE(LOOKUP_CODE
, 'PRODUCT'
, MEANING)) PRODUCT_MEANING
, MAX(DECODE(LOOKUP_CODE
, 'SERIAL NUM'
, LOOKUP_CODE)) SERIAL_NUM_CODE
, MAX(DECODE(LOOKUP_CODE
, 'SERIAL NUM'
, MEANING)) SERIAL_NUM_MEANING
, MAX(DECODE(LOOKUP_CODE
, 'SUBTYPE'
, LOOKUP_CODE)) SUBTYPE_CODE
, MAX(DECODE(LOOKUP_CODE
, 'SUBTYPE'
, MEANING)) SUBTYPE_MEANING
, MAX(DECODE(LOOKUP_CODE
, 'MATCH'
, LOOKUP_CODE)) MATCH_CODE
, MAX(DECODE(LOOKUP_CODE
, 'MATCH'
, MEANING)) MATCH_MEANING
, MAX(DECODE(LOOKUP_CODE
, 'SUM DATE'
, LOOKUP_CODE)) SUMDATE_CODE
, MAX(DECODE(LOOKUP_CODE
, 'SUM DATE'
, MEANING)) SUMDATE_MEANING
, MAX(DECODE(LOOKUP_CODE
, 'SUM RANGE'
, LOOKUP_CODE)) SUMRANGE_CODE
, MAX(DECODE(LOOKUP_CODE
, 'SUM RANGE'
, MEANING)) SUMRANGE_MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE IN ('XTR_RECON_ON_COLUMN'
, 'XTR_RECON_CRITERIA') ) D
WHERE 1=1

Columns