JV_MEASURE_INFO_V

Details

• Schema: FUSION

• Object owner: JV

• Object type: VIEW

Columns

Name
MEASURE_DOCUMENT_ID JOINT_VENTURE_SHORT_NAME MEASURE_DOCUMENT_NUMBER

Query

SQL_Statement
SELECT JA.ACCOUNTING_HEADER_ID MEASURE_DOCUMENT_ID, JV.JOINT_VENTURE_SHORT_NAME JOINT_VENTURE_SHORT_NAME, JA.DOCUMENT_NUMBER MEASURE_DOCUMENT_NUMBER FROM JV_ACCOUNTING_HEADERS JA, JV_JOINT_VENTURES_B JV WHERE JV.JOINT_VENTURE_ID = JA.JOINT_VENTURE_ID