eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: CEBV_STMTRECON

Product:	CE - Cash Management
Description:	Business View
Implementation/DBA Data:	APPS.CEBV_STMTRECON

View Text

SELECT SR.STATEMENT_LINE_ID
, SR.REFERENCE_TYPE
, SR.REFERENCE_ID
, SR.JE_HEADER_ID
, SR.CREATION_DATE
, L1.MEANING
, SR.AMOUNT
, SR.ORG_ID
, SR.REFERENCE_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, SR.CREATION_DATE
, SR.CREATED_BY
, SR.LAST_UPDATE_DATE
, SR.LAST_UPDATED_BY
FROM CE_STATEMENT_RECONCILS_ALL SR
, CE_LOOKUPS L1
WHERE SR.CURRENT_RECORD_FLAG = 'Y'
AND SR.STATUS_FLAG = 'M'
AND SR.REFERENCE_TYPE = 'JE_LINE'
AND L1.LOOKUP_TYPE = 'YES/NO'
AND L1.LOOKUP_CODE = SR.AUTO_RECONCILED_FLAG
AND '_SEC:SR.ORG_ID' IS NOT NULL UNION ALL SELECT SR.STATEMENT_LINE_ID
, SR.REFERENCE_TYPE
, SR.REFERENCE_ID
, TO_NUMBER(NULL)
, SR.CREATION_DATE
, L1.MEANING
, SR.AMOUNT
, SR.ORG_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, SR.REFERENCE_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, SR.CREATION_DATE
, SR.CREATED_BY
, SR.LAST_UPDATE_DATE
, SR.LAST_UPDATED_BY
FROM CE_STATEMENT_RECONCILS_ALL SR
, CE_LOOKUPS L1
WHERE SR.CURRENT_RECORD_FLAG = 'Y'
AND SR.STATUS_FLAG = 'M'
AND SR.REFERENCE_TYPE = 'PAYMENT'
AND L1.LOOKUP_TYPE = 'YES/NO'
AND L1.LOOKUP_CODE = SR.AUTO_RECONCILED_FLAG
AND '_SEC:SR.ORG_ID' IS NOT NULL UNION ALL SELECT SR.STATEMENT_LINE_ID
, SR.REFERENCE_TYPE
, SR.REFERENCE_ID
, TO_NUMBER(NULL)
, SR.CREATION_DATE
, L1.MEANING
, SR.AMOUNT
, SR.ORG_ID
, TO_NUMBER(NULL)
, SR.REFERENCE_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, SR.CREATION_DATE
, SR.CREATED_BY
, SR.LAST_UPDATE_DATE
, SR.LAST_UPDATED_BY
FROM CE_STATEMENT_RECONCILS_ALL SR
, CE_LOOKUPS L1
WHERE SR.CURRENT_RECORD_FLAG = 'Y'
AND SR.STATUS_FLAG = 'M'
AND SR.REFERENCE_TYPE = 'RECEIPT'
AND L1.LOOKUP_TYPE = 'YES/NO'
AND L1.LOOKUP_CODE = SR.AUTO_RECONCILED_FLAG
AND '_SEC:SR.ORG_ID' IS NOT NULL UNION ALL SELECT SR.STATEMENT_LINE_ID
, SR.REFERENCE_TYPE
, SR.REFERENCE_ID
, TO_NUMBER(NULL)
, SR.CREATION_DATE
, L1.MEANING
, SR.AMOUNT
, SR.ORG_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, SR.REFERENCE_ID
, TO_NUMBER(NULL)
, SR.CREATION_DATE
, SR.CREATED_BY
, SR.LAST_UPDATE_DATE
, SR.LAST_UPDATED_BY
FROM CE_STATEMENT_RECONCILS_ALL SR
, CE_LOOKUPS L1
WHERE SR.CURRENT_RECORD_FLAG = 'Y'
AND SR.STATUS_FLAG = 'M'
AND SR.REFERENCE_TYPE = 'STATEMENT'
AND L1.LOOKUP_TYPE = 'YES/NO'
AND L1.LOOKUP_CODE = SR.AUTO_RECONCILED_FLAG
AND '_SEC:SR.ORG_ID' IS NOT NULL UNION ALL SELECT SR.STATEMENT_LINE_ID
, SR.REFERENCE_TYPE
, SR.REFERENCE_ID
, TO_NUMBER(NULL)
, SR.CREATION_DATE
, L1.MEANING
, SR.AMOUNT
, SR.ORG_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, SR.REFERENCE_ID
, SR.CREATION_DATE
, SR.CREATED_BY
, SR.LAST_UPDATE_DATE
, SR.LAST_UPDATED_BY
FROM CE_STATEMENT_RECONCILS_ALL SR
, CE_LOOKUPS L1
WHERE SR.CURRENT_RECORD_FLAG = 'Y'
AND SR.STATUS_FLAG = 'M'
AND SR.REFERENCE_TYPE = 'ROI_LINE'
AND L1.LOOKUP_TYPE = 'YES/NO'
AND L1.LOOKUP_CODE = SR.AUTO_RECONCILED_FLAG
AND '_SEC:SR.ORG_ID' IS NOT NULL UNION ALL SELECT SR.STATEMENT_LINE_ID
, SR.REFERENCE_TYPE
, SR.REFERENCE_ID
, TO_NUMBER(NULL)
, SR.CREATION_DATE
, L1.MEANING
, SR.AMOUNT
, SR.ORG_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, SR.REFERENCE_ID
, SR.CREATION_DATE
, SR.CREATED_BY
, SR.LAST_UPDATE_DATE
, SR.LAST_UPDATED_BY
FROM CE_STATEMENT_RECONCILS_ALL SR
, CE_LOOKUPS L1
WHERE SR.CURRENT_RECORD_FLAG = 'Y'
AND SR.STATUS_FLAG = 'M'
AND SR.REFERENCE_TYPE = 'CASHFLOW'
AND L1.LOOKUP_TYPE = 'YES/NO'
AND L1.LOOKUP_CODE = SR.AUTO_RECONCILED_FLAG
AND '_SEC:SR.ORG_ID' IS NOT NULL WITH READ ONLY

Columns

Name
STATEMENT_LINE_ID
MATCHING_TRANSACTION_TYPE_CODE
MATCHING_TRANSACTION_ID
JOURNAL_HEADER_ID
RECONCILIATION_DATE
AUTOMATICALLY_RECONCILED_FLAG
AMOUNT
ORG_ID
JOURNAL_LINE_NUMBER
CASH_RECEIPT_HISTORY_ID
CHECK_ID
MATCHING_STATEMENT_LINE_ID
EXTERNAL_TRX_ID
CREATED_DATE
CREATED_BY
LAST_UPDATED_DATE
LAST_UPDATED_BY