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.

VIEW: APPS.CEFV_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, og.name, sr.org_id, sl.line_number, jh.name, 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, hr_all_organization_units og, ce_statement_lines sl, gl_je_headers jh, ce_lookups l1 where sr.current_record_flag = 'Y' and sr.status_flag = 'M' and sr.reference_type = 'JE_LINE' and sr.statement_line_id = sl.statement_line_id and sr.org_id = og.organization_id (+) and jh.je_header_id = sr.je_header_id 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, sr.je_header_id, sr.creation_date, l1.meaning, sr.amount, og.name, sr.org_id, sl.line_number, null, 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, hr_all_organization_units og, ce_statement_lines sl, ce_lookups l1 where sr.current_record_flag = 'Y' and sr.status_flag = 'M' and sr.reference_type = 'PAYMENT' and sr.statement_line_id = sl.statement_line_id and sr.org_id = og.organization_id (+) 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, sr.je_header_id, sr.creation_date, l1.meaning, sr.amount, og.name, sr.org_id, sl.line_number, null, 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, hr_all_organization_units og, ce_statement_lines sl, ce_lookups l1 where sr.current_record_flag = 'Y' and sr.status_flag = 'M' and sr.reference_type = 'RECEIPT' and sr.statement_line_id = sl.statement_line_id and sr.org_id = og.organization_id (+) 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, sr.je_header_id, sr.creation_date, l1.meaning, sr.amount, og.name, sr.org_id, sl.line_number, null, 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, hr_all_organization_units og, ce_statement_lines sl, ce_lookups l1 where sr.current_record_flag = 'Y' and sr.status_flag = 'M' and sr.reference_type = 'STATEMENT' and sr.statement_line_id = sl.statement_line_id and sr.org_id = og.organization_id (+) 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, sr.je_header_id, sr.creation_date, l1.meaning, sr.amount, og.name, sr.org_id, sl.line_number, null, 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, hr_all_organization_units og, ce_statement_lines sl, ce_lookups l1 where sr.current_record_flag = 'Y' and sr.status_flag = 'M' and sr.reference_type = 'ROI_LINE' and sr.statement_line_id = sl.statement_line_id and sr.org_id = og.organization_id (+) 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
, OG.NAME
, SR.ORG_ID
, SL.LINE_NUMBER
, JH.NAME
, 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
, HR_ALL_ORGANIZATION_UNITS OG
, CE_STATEMENT_LINES SL
, GL_JE_HEADERS JH
, CE_LOOKUPS L1
WHERE SR.CURRENT_RECORD_FLAG = 'Y'
AND SR.STATUS_FLAG = 'M'
AND SR.REFERENCE_TYPE = 'JE_LINE'
AND SR.STATEMENT_LINE_ID = SL.STATEMENT_LINE_ID
AND SR.ORG_ID = OG.ORGANIZATION_ID (+)
AND JH.JE_HEADER_ID = SR.JE_HEADER_ID
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
, SR.JE_HEADER_ID
, SR.CREATION_DATE
, L1.MEANING
, SR.AMOUNT
, OG.NAME
, SR.ORG_ID
, SL.LINE_NUMBER
, NULL
, 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
, HR_ALL_ORGANIZATION_UNITS OG
, CE_STATEMENT_LINES SL
, CE_LOOKUPS L1
WHERE SR.CURRENT_RECORD_FLAG = 'Y'
AND SR.STATUS_FLAG = 'M'
AND SR.REFERENCE_TYPE = 'PAYMENT'
AND SR.STATEMENT_LINE_ID = SL.STATEMENT_LINE_ID
AND SR.ORG_ID = OG.ORGANIZATION_ID (+)
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
, SR.JE_HEADER_ID
, SR.CREATION_DATE
, L1.MEANING
, SR.AMOUNT
, OG.NAME
, SR.ORG_ID
, SL.LINE_NUMBER
, NULL
, 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
, HR_ALL_ORGANIZATION_UNITS OG
, CE_STATEMENT_LINES SL
, CE_LOOKUPS L1
WHERE SR.CURRENT_RECORD_FLAG = 'Y'
AND SR.STATUS_FLAG = 'M'
AND SR.REFERENCE_TYPE = 'RECEIPT'
AND SR.STATEMENT_LINE_ID = SL.STATEMENT_LINE_ID
AND SR.ORG_ID = OG.ORGANIZATION_ID (+)
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
, SR.JE_HEADER_ID
, SR.CREATION_DATE
, L1.MEANING
, SR.AMOUNT
, OG.NAME
, SR.ORG_ID
, SL.LINE_NUMBER
, NULL
, 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
, HR_ALL_ORGANIZATION_UNITS OG
, CE_STATEMENT_LINES SL
, CE_LOOKUPS L1
WHERE SR.CURRENT_RECORD_FLAG = 'Y'
AND SR.STATUS_FLAG = 'M'
AND SR.REFERENCE_TYPE = 'STATEMENT'
AND SR.STATEMENT_LINE_ID = SL.STATEMENT_LINE_ID
AND SR.ORG_ID = OG.ORGANIZATION_ID (+)
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
, SR.JE_HEADER_ID
, SR.CREATION_DATE
, L1.MEANING
, SR.AMOUNT
, OG.NAME
, SR.ORG_ID
, SL.LINE_NUMBER
, NULL
, 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
, HR_ALL_ORGANIZATION_UNITS OG
, CE_STATEMENT_LINES SL
, CE_LOOKUPS L1
WHERE SR.CURRENT_RECORD_FLAG = 'Y'
AND SR.STATUS_FLAG = 'M'
AND SR.REFERENCE_TYPE = 'ROI_LINE'
AND SR.STATEMENT_LINE_ID = SL.STATEMENT_LINE_ID
AND SR.ORG_ID = OG.ORGANIZATION_ID (+)
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