XLA_CST_DISTRIBUTION_LINES_VL

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
AE_HEADER_ID AE_LINE_NUM GL_TRANSFER_DATE GL_TRANSFER_STATUS_CODE XLA_AE_HDR_ID GL_BATCH_NAME GL_BATCH_DESC GL_BATCH_STATUS

Query

SQL_Statement

SELECT HDR.AE_HEADER_ID, L.AE_LINE_NUM, HDR.GL_TRANSFER_DATE, HDR.GL_TRANSFER_STATUS_CODE, HDR.AE_HEADER_ID AS XLA_AE_HDR_ID, B.NAME GL_BATCH_NAME, B.DESCRIPTION GL_BATCH_DESC, B.STATUS GL_BATCH_STATUS FROM XLA_AE_LINES L, XLA_AE_HEADERS HDR, GL_IMPORT_REFERENCES IR, GL_JE_BATCHES B, GL_JE_HEADERS JH WHERE HDR.APPLICATION_ID = 707 AND L.AE_HEADER_ID = HDR.AE_HEADER_ID AND L.GL_SL_LINK_ID = IR.GL_SL_LINK_ID (+) AND L.GL_SL_LINK_TABLE = IR.GL_SL_LINK_TABLE (+) AND IR.JE_BATCH_ID = B.JE_BATCH_ID (+) AND NVL(B.PARENT_JE_BATCH_ID, 0) = 0 AND JH.JE_HEADER_ID = IR.JE_HEADER_ID AND JH.LEDGER_ID = HDR.LEDGER_ID AND HDR.ACCOUNTING_DATE >= NVL(to_date(SYS_CONTEXT('CST_CA_OTBI_PARAMS','p_gl_from_date'),'YYYY-MM-DD'), to_date('01/01/1900','mm/dd/yyyy')) AND HDR.ACCOUNTING_DATE <= NVL(to_date(SYS_CONTEXT('CST_CA_OTBI_PARAMS','p_gl_to_date'),'YYYY-MM-DD'), to_date('12/31/4712','mm/dd/yyyy'))