GL_LEDGER_LE_V
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: VIEW
Columns
Name |
---|
LEDGER_ID LEDGER_NAME LEDGER_SHORT_NAME LEGAL_ENTITY_ID LEGAL_ENTITY_NAME LOCATION_ID LOCATION_CODE LOCATION_DESCRIPTION LEDGER_CATEGORY_CODE CURRENCY_CODE CHART_OF_ACCOUNTS_ID PERIOD_SET_NAME ACCOUNTED_PERIOD_TYPE SLA_ACCOUNTING_METHOD_CODE SLA_ACCOUNTING_METHOD_TYPE BAL_SEG_VALUE_OPTION_CODE BAL_SEG_COLUMN_NAME BAL_SEG_VALUE_SET_ID ACCTG_ENVIRONMENT_CODE CONFIGURATION_ID PRIMARY_LEDGER_ID RELATIONSHIP_ENABLED_FLAG |
Query
SQL_Statement |
---|
SELECT lg.LEDGER_ID LEDGER_ID, lg.NAME LEDGER_NAME , lg.SHORT_NAME LEDGER_SHORT_NAME , le.LEGAL_ENTITY_ID LEGAL_ENTITY_ID , le.NAME LEGAL_ENTITY_NAME , reg.LOCATION_ID LOCATION_ID , hrloc.LOCATION_CODE LOCATION_CODE , hrloc.DESCRIPTION LOCATION_DESCRIPTION , lg.LEDGER_CATEGORY_CODE LEDGER_CATEGORY_CODE, lg.CURRENCY_CODE CURRENCY_CODE, lg.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID, lg.PERIOD_SET_NAME PERIOD_SET_NAME, lg.ACCOUNTED_PERIOD_TYPE ACCOUNTED_PERIOD_TYPE, lg.SLA_ACCOUNTING_METHOD_CODE SLA_ACCOUNTING_METHOD_CODE , lg.SLA_ACCOUNTING_METHOD_TYPE SLA_ACCOUNTING_METHOD_TYPE, lg.BAL_SEG_VALUE_OPTION_CODE BAL_SEG_VALUE_OPTION_CODE, lg.BAL_SEG_COLUMN_NAME BAL_SEG_COLUMN_NAME, lg.BAL_SEG_VALUE_SET_ID BAL_SEG_VALUE_SET_ID, cfg.ACCTG_ENVIRONMENT_CODE ACCTG_ENVIRONMENT_CODE, cfg.CONFIGURATION_ID CONFIGURATION_ID, rs.PRIMARY_LEDGER_ID PRIMARY_LEDGER_ID, rs.RELATIONSHIP_ENABLED_FLAG RELATIONSHIP_ENABLED_FLAG FROM GL_LEDGER_CONFIG_DETAILS primDet , GL_LEDGERS lg , GL_LEDGER_RELATIONSHIPS rs , GL_LEDGER_CONFIGURATIONS cfg , GL_LEDGER_CONFIG_DETAILS cfgDet , XLE_ENTITY_PROFILES le , XLE_REGISTRATIONS reg , HR_LOCATIONS hrloc WHERE rs.application_id = 101 AND ( (rs.target_ledger_category_code = 'SECONDARY' AND rs.relationship_type_code <> 'NONE' ) OR (rs.target_ledger_category_code = 'PRIMARY' AND rs.relationship_type_code = 'NONE' ) OR (rs.target_ledger_category_code = 'ALC' AND rs.relationship_type_code IN ('JOURNAL', 'SUBLEDGER') ) ) AND lg.ledger_id = rs.target_ledger_id AND lg.ledger_category_code = rs.target_ledger_category_code AND nvl(lg.complete_flag, 'Y') = 'Y' AND primDet.object_id = rs.primary_ledger_id AND primDet.object_type_code = 'PRIMARY' AND primDet.setup_step_code = 'NONE' AND cfg.configuration_id = primDet.configuration_id AND cfgDet.configuration_id (+) = cfg.configuration_id AND cfgDet.object_type_code (+) = 'LEGAL_ENTITY' AND cfgDet.setup_step_code (+) = 'NONE' AND le.legal_entity_id (+) = cfgDet.object_id AND reg.source_id (+) = cfgDet.object_id AND reg.source_table (+) = 'XLE_ENTITY_PROFILES' AND reg.identifying_flag (+) = 'Y' AND hrloc.location_id (+) = reg.location_id |