CST_XLA_GL_OVERRIDE_ACCTS_VL

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
SLA_CODE_COMBINATION_ID ENTITY_CODE DISTRIBUTION_LINE_ID SLA_LEDGER_AMOUNT SLA_DR_CR_SIGN

Query

SQL_Statement

SELECT l.code_combination_id sla_code_combination_id, h.source_distribution_type entity_code, h.source_distribution_id_num_1 distribution_line_id, NVL(L.ACCOUNTED_DR, L.ACCOUNTED_CR) SLA_LEDGER_AMOUNT, DECODE(L.ACCOUNTED_DR, NULL, 'CR', 'DR') SLA_DR_CR_SIGN FROM xla_ae_lines l, xla_distribution_links h WHERE l.ae_header_id = h.ae_header_id AND l.ae_line_num = h.ae_line_num AND h.application_id = 707