JV_CI_JOURNAL_HEADER_V

Details

• Schema: FUSION

• Object owner: JV

• Object type: VIEW

Columns

Name
CARRIED_INTEREST_DOCUMENT_ID CARRIED_INTEREST_DOC_NUMBER JOINT_VENTURE_ID JOINT_VENTURE_SHORT_NAME AGREEMENT_ID AGREEMENT_SHORT_NAME ACCOUNTING_DATE EVENT_ID LEDGER_NAME

Query

SQL_Statement

SELECT JA.ACCOUNTING_HEADER_ID CARRIED_INTEREST_DOCUMENT_ID, JA.DOCUMENT_NUMBER CARRIED_INTEREST_DOC_NUMBER, JA.JOINT_VENTURE_ID JOINT_VENTURE_ID, JV.JOINT_VENTURE_SHORT_NAME JOINT_VENTURE_SHORT_NAME, CI.AGREEMENT_ID AGREEMENT_ID, CI.AGREEMENT_SHORT_NAME AGREEMENT_SHORT_NAME, 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_CI_AGREEMENTS_B CI, GL_LEDGERS GL WHERE JV.JOINT_VENTURE_ID = JA.JOINT_VENTURE_ID AND CI.AGREEMENT_ID = JA.AGREEMENT_ID AND GL.LEDGER_ID = JA.LEDGER_ID