GL_SECONDARY_LEDGER_RSHIPS_V

Details

• Schema: FUSION

• Object owner: GL

• Object type: VIEW

Columns

Name
PRIMARY_LEDGER_ID LEDGER_ID LEDGER_NAME LEDGER_SHORT_NAME CHART_OF_ACCOUNTS_ID CURRENCY_CODE PERIOD_SET_NAME ACCOUNTED_PERIOD_TYPE SL_COA_MAPPING_ID SLA_ACCOUNTING_METHOD_CODE SLA_ACCOUNTING_METHOD_TYPE RELATIONSHIP_TYPE_CODE RELATIONSHIP_ENABLED_FLAG

Query

SQL_Statement

SELECT rs.PRIMARY_LEDGER_ID , lg.LEDGER_ID , lg.NAME , lg.SHORT_NAME , lg.CHART_OF_ACCOUNTS_ID , lg.CURRENCY_CODE , lg.PERIOD_SET_NAME , lg.ACCOUNTED_PERIOD_TYPE , rs.SL_COA_MAPPING_ID , lg.SLA_ACCOUNTING_METHOD_CODE , lg.SLA_ACCOUNTING_METHOD_TYPE , rs.RELATIONSHIP_TYPE_CODE , rs.RELATIONSHIP_ENABLED_FLAG FROM GL_LEDGER_RELATIONSHIPS rs , GL_LEDGERS lg WHERE lg.ledger_category_code = 'SECONDARY' AND nvl(lg.complete_flag,'Y') = 'Y' AND rs.target_ledger_id = lg.ledger_id AND rs.target_ledger_category_code = lg.ledger_category_code AND rs.relationship_type_code <> 'NONE' AND rs.application_id = 101