JV_PC_JOURNAL_LINE_VL

Details

• Schema: FUSION

• Object owner: JV

• Object type: VIEW

Columns

Name
LINE_NUMBER LANGUAGE EVENT_ID TO_JOINT_VENTURE_NAME TO_STAKEHOLDER_NAME

Query

SQL_Statement

SELECT FROM_CR.CONTRIBUTION_REFERENCE_ID LINE_NUMBER, TO_JV.LANGUAGE LANGUAGE, JA.EVENT_ID EVENT_ID, TO_JV.JOINT_VENTURE_NAME TO_JOINT_VENTURE_NAME, TO_SH.STAKEHOLDER_NAME TO_STAKEHOLDER_NAME FROM JV_ACCOUNTING_HEADERS JA, JV_CONTRIBUTIONS_B FROM_PC, JV_CONTRIBUTION_REFERENCES FROM_CR, JV_CONTRIBUTIONS_B TO_PC, JV_JOINT_VENTURES_TL TO_JV, JV_STAKEHOLDERS_TL TO_SH WHERE FROM_PC.CONTRIBUTION_ID = JA.CONTRIBUTION_ID AND FROM_CR.CONTRIBUTION_ID = FROM_PC.CONTRIBUTION_ID AND FROM_CR.TRANSACTION_ID = JA.ACCOUNTING_HEADER_ID AND TO_PC.CONTRIBUTION_ID(+) = FROM_CR.RELATED_CONTRIBUTION_ID AND TO_JV.JOINT_VENTURE_ID(+) = TO_PC.JOINT_VENTURE_ID AND TO_SH.STAKEHOLDER_ID(+) = TO_PC.STAKEHOLDER_ID AND TO_JV.LANGUAGE(+) = TO_SH.LANGUAGE