JV_PC_JOURNAL_INFO_V

Details

• Schema: FUSION

• Object owner: JV

• Object type: VIEW

Columns

Name
CONTRIBUTION_DOCUMENT_ID CONTRIBUTION_DOC_NUMBER FROM_JOINT_VENTURE_SHORT_NAME FROM_STAKEHOLDER_SHORT_NAME FROM_START_DATE FROM_SEQUENCE_NUMBER

Query

SQL_Statement

SELECT JA.ACCOUNTING_HEADER_ID CONTRIBUTION_DOCUMENT_ID, JA.DOCUMENT_NUMBER CONTRIBUTION_DOC_NUMBER, JV.JOINT_VENTURE_SHORT_NAME FROM_JOINT_VENTURE_SHORT_NAME, SH.STAKEHOLDER_SHORT_NAME FROM_STAKEHOLDER_SHORT_NAME, PC.START_DATE FROM_START_DATE, PC.SEQUENCE_NUMBER FROM_SEQUENCE_NUMBER FROM JV_ACCOUNTING_HEADERS JA, JV_JOINT_VENTURES_B JV, JV_STAKEHOLDERS_B SH, JV_CONTRIBUTIONS_B PC, JV_CONTRIBUTION_REFERENCES CR WHERE JV.JOINT_VENTURE_ID = JA.JOINT_VENTURE_ID AND SH.STAKEHOLDER_ID = JA.STAKEHOLDER_ID AND PC.CONTRIBUTION_ID = JA.CONTRIBUTION_ID AND CR.CONTRIBUTION_ID = PC.CONTRIBUTION_ID AND CR.TRANSACTION_ID = JA.ACCOUNTING_HEADER_ID