XLA_CMR_RCV_EVNT_DSTRBNS_V

Details

• Schema: FUSION

• Object owner: CMR

• Object type: VIEW

Columns

Name
ACCOUNTING_EVENT_ID CMR_SUB_LEDGER_ID CODE_COMBINATION_ID GL_TRANSFER_DATE GL_TRANSFER_STATUS_CODE SOURCE_DISTRIBUTION_TYPE SOURCE_DISTRIBUTION_ID_NUM_1 CALCULATE_G_L_AMTS_FLAG XLA_AE_HDR_ID XLA_DIST_LINKS_AE_HDR_ID GL_BATCH_NAME GL_BATCH_DESC GL_BATCH_STATUS BALANCE_TYPE_CODE

Query

SQL_Statement

SELECT DL.ACCOUNTING_EVENT_ID , DL.CMR_SUB_LEDGER_ID, L.CODE_COMBINATION_ID, HDR.GL_TRANSFER_DATE, HDR.GL_TRANSFER_STATUS_CODE, H.SOURCE_DISTRIBUTION_TYPE, H.SOURCE_DISTRIBUTION_ID_NUM_1, H.CALCULATE_G_L_AMTS_FLAG, HDR.AE_HEADER_ID AS XLA_AE_HDR_ID, H.AE_HEADER_ID AS XLA_DIST_LINKS_AE_HDR_ID, B.NAME GL_BATCH_NAME, B.DESCRIPTION GL_BATCH_DESC, B.STATUS GL_BATCH_STATUS, HDR.BALANCE_TYPE_CODE FROM CMR_RCV_EVENTS CCD, XLA_DISTRIBUTION_LINKS H, XLA_AE_LINES L, XLA_AE_HEADERS HDR, CMR_RCV_DISTRIBUTIONS DL, GL_IMPORT_REFERENCES IR, GL_JE_BATCHES B, GL_JE_HEADERS JH WHERE CCD.ACCOUNTING_EVENT_ID = DL.ACCOUNTING_EVENT_ID AND H.SOURCE_DISTRIBUTION_TYPE = CCD.ENTITY_CODE AND H.SOURCE_DISTRIBUTION_ID_NUM_1 = DL.CMR_SUB_LEDGER_ID AND H.CALCULATE_G_L_AMTS_FLAG = 'N' AND L.AE_HEADER_ID = H.AE_HEADER_ID AND L.AE_LINE_NUM = H.AE_LINE_NUM AND HDR.AE_HEADER_ID = H.AE_HEADER_ID AND HDR.APPLICATION_ID = 10096 AND HDR.LEDGER_ID = CCD.LEDGER_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