JV_PC_JOURNAL_HEADER_VL

Details

• Schema: FUSION

• Object owner: JV

• Object type: VIEW

Columns

Name
LANGUAGE EVENT_ID FROM_JOINT_VENTURE_NAME FROM_STAKEHOLDER_NAME

Query

SQL_Statement
SELECT JV.LANGUAGE LANGUAGE, JA.EVENT_ID EVENT_ID, JV.JOINT_VENTURE_NAME FROM_JOINT_VENTURE_NAME, SH.STAKEHOLDER_NAME FROM_STAKEHOLDER_NAME FROM JV_ACCOUNTING_HEADERS JA, JV_JOINT_VENTURES_TL JV, JV_STAKEHOLDERS_TL SH WHERE JV.JOINT_VENTURE_ID = JA.JOINT_VENTURE_ID AND SH.STAKEHOLDER_ID = JA.STAKEHOLDER_ID AND JV.LANGUAGE = SH.LANGUAGE