JV_INTERNAL_TRANSFER_HEADER_VL

Details

• Schema: FUSION

• Object owner: JV

• Object type: VIEW

Columns

Name
LANGUAGE EVENT_ID JOINT_VENTURE_NAME STAKEHOLDER_NAME

Query

SQL_Statement
SELECT JV.LANGUAGE LANGUAGE, JA.EVENT_ID EVENT_ID, JV.JOINT_VENTURE_NAME JOINT_VENTURE_NAME, SH.STAKEHOLDER_NAME 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 SH.LANGUAGE = JV.LANGUAGE