JV_STAKEHOLDER_RPTG_INFO_V

Details

• Schema: FUSION

• Object owner: JV

• Object type: VIEW

Columns

Name
STAKEHOLDER_RPTG_DOC_ID JOINT_VENTURE_SHORT_NAME STAKEHOLDER_RPTG_DOC_NUMBER

Query

SQL_Statement
SELECT JA.ACCOUNTING_HEADER_ID STAKEHOLDER_RPTG_DOC_ID, JV.JOINT_VENTURE_SHORT_NAME JOINT_VENTURE_SHORT_NAME, JA.DOCUMENT_NUMBER STAKEHOLDER_RPTG_DOC_NUMBER FROM JV_ACCOUNTING_HEADERS JA, JV_JOINT_VENTURES_B JV WHERE JV.JOINT_VENTURE_ID = JA.JOINT_VENTURE_ID