View: CEFV_STMTRECON

Product:	CE - Cash Management
Description:	Business View
Implementation/DBA Data:	APPS.CEFV_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
, 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

Columns