VIEW: APPS.CEBV_STMTRECON

Source

View Text - Preformatted

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

View Text - HTML Formatted

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