GL_ALC_LEDGER_RSHIPS

Details

Schema: FUSION
Object owner: GL
Object type: VIEW

Columns

Name
SOURCE_LEDGER_ID LEDGER_ID LEDGER_NAME LEDGER_SHORT_NAME CURRENCY_CODE RELATIONSHIP_TYPE_CODE RELATIONSHIP_ENABLED_FLAG PRIMARY_LEDGER_ID APPLICATION_ID ORG_ID ALC_DEFAULT_CONV_RATE_TYPE

Name

SOURCE_LEDGER_ID

LEDGER_ID

LEDGER_NAME

LEDGER_SHORT_NAME

CURRENCY_CODE

RELATIONSHIP_TYPE_CODE

RELATIONSHIP_ENABLED_FLAG

PRIMARY_LEDGER_ID

APPLICATION_ID

ORG_ID

ALC_DEFAULT_CONV_RATE_TYPE

Query

SQL_Statement
SELECT SOURCE_LEDGER_ID , TARGET_LEDGER_ID LEDGER_ID , TARGET_LEDGER_NAME NAME , TARGET_LEDGER_SHORT_NAME SHORT_NAME , TARGET_CURRENCY_CODE CURRENCY_CODE , RELATIONSHIP_TYPE_CODE , RELATIONSHIP_ENABLED_FLAG , PRIMARY_LEDGER_ID , APPLICATION_ID , ORG_ID , ALC_DEFAULT_CONV_RATE_TYPE FROM GL_LEDGER_RELATIONSHIPS REL, GL_LEDGERS LGR WHERE target_ledger_category_code = 'ALC' AND relationship_type_code IN ('JOURNAL', 'SUBLEDGER') AND LGR.ledger_id = REL.target_ledger_id AND nvl(LGR.complete_flag, 'Y') = 'Y'

SQL_Statement

SELECT SOURCE_LEDGER_ID , TARGET_LEDGER_ID LEDGER_ID , TARGET_LEDGER_NAME NAME , TARGET_LEDGER_SHORT_NAME SHORT_NAME , TARGET_CURRENCY_CODE CURRENCY_CODE , RELATIONSHIP_TYPE_CODE , RELATIONSHIP_ENABLED_FLAG , PRIMARY_LEDGER_ID , APPLICATION_ID , ORG_ID , ALC_DEFAULT_CONV_RATE_TYPE FROM GL_LEDGER_RELATIONSHIPS REL, GL_LEDGERS LGR WHERE target_ledger_category_code = 'ALC' AND relationship_type_code IN ('JOURNAL', 'SUBLEDGER') AND LGR.ledger_id = REL.target_ledger_id AND nvl(LGR.complete_flag, 'Y') = 'Y'