JV_CI_JOURNAL_HEADER_VL

Details

• Schema: FUSION

• Object owner: JV

• Object type: VIEW

Columns

Name
LANGUAGE EVENT_ID JOINT_VENTURE_NAME AGREEMENT_NAME

Query

SQL_Statement
SELECT JV.LANGUAGE LANGUAGE, JA.EVENT_ID EVENT_ID, JV.JOINT_VENTURE_NAME JOINT_VENTURE_NAME, CI.AGREEMENT_NAME AGREEMENT_NAME FROM JV_ACCOUNTING_HEADERS JA, JV_JOINT_VENTURES_TL JV, JV_CI_AGREEMENTS_TL CI WHERE JV.JOINT_VENTURE_ID = JA.JOINT_VENTURE_ID AND CI.AGREEMENT_ID = JA.AGREEMENT_ID AND CI.LANGUAGE = JV.LANGUAGE