GL_LEDGER_LE

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

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

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