JV_PC_JOURNAL_HEADER_V

Details

• Schema: FUSION

• Object owner: JV

• Object type: VIEW

Columns

Name
CONTRIBUTION_DOCUMENT_ID CONTRIBUTION_DOC_NUMBER FROM_JOINT_VENTURE_ID FROM_JOINT_VENTURE_SHORT_NAME FROM_STAKEHOLDER_ID FROM_STAKEHOLDER_SHORT_NAME FROM_START_DATE FROM_SEQUENCE_NUMBER ACCOUNTING_DATE EVENT_ID LEDGER_NAME

Query

SQL_Statement

SELECT JA.ACCOUNTING_HEADER_ID CONTRIBUTION_DOCUMENT_ID, JA.DOCUMENT_NUMBER CONTRIBUTION_DOC_NUMBER, JA.JOINT_VENTURE_ID FROM_JOINT_VENTURE_ID, JV.JOINT_VENTURE_SHORT_NAME FROM_JOINT_VENTURE_SHORT_NAME, JA.STAKEHOLDER_ID FROM_STAKEHOLDER_ID, SH.STAKEHOLDER_SHORT_NAME FROM_STAKEHOLDER_SHORT_NAME, PC.START_DATE FROM_START_DATE, PC.SEQUENCE_NUMBER FROM_SEQUENCE_NUMBER, JA.ACCOUNTING_DATE ACCOUNTING_DATE, JA.EVENT_ID EVENT_ID, GL.NAME LEDGER_NAME FROM JV_ACCOUNTING_HEADERS JA, JV_JOINT_VENTURES_B JV, JV_STAKEHOLDERS_B SH, GL_LEDGERS GL, 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 AND GL.LEDGER_ID = JA.LEDGER_ID