1. Tables and Views for Financials
  2. JV_CI_JOURNAL_INFO_V

JV_CI_JOURNAL_INFO_V

Details

  • Schema: FUSION

  • Object owner: JV

  • Object type: VIEW

Columns

Name

CARRIED_INTEREST_DOCUMENT_ID

JOINT_VENTURE_SHORT_NAME

AGREEMENT_SHORT_NAME

CARRIED_INTEREST_DOC_NUMBER

Query

SQL_Statement

SELECT

JA.ACCOUNTING_HEADER_ID CARRIED_INTEREST_DOCUMENT_ID,

JV.JOINT_VENTURE_SHORT_NAME JOINT_VENTURE_SHORT_NAME,

CI.AGREEMENT_SHORT_NAME AGREEMENT_SHORT_NAME,

JA.DOCUMENT_NUMBER CARRIED_INTEREST_DOC_NUMBER

FROM

JV_ACCOUNTING_HEADERS JA,

JV_JOINT_VENTURES_B JV,

JV_CI_AGREEMENTS_B CI

WHERE

JV.JOINT_VENTURE_ID = JA.JOINT_VENTURE_ID AND

CI.AGREEMENT_ID = JA.AGREEMENT_ID