JV_MEASURE_HEADER_V

Details

• Schema: FUSION

• Object owner: JV

• Object type: VIEW

Columns

Name
MEASURE_DOCUMENT_ID MEASURE_DOCUMENT_NUMBER JOINT_VENTURE_ID JOINT_VENTURE_SHORT_NAME ACCOUNTING_DATE EVENT_ID LEDGER_NAME

Query

SQL_Statement

SELECT JA.ACCOUNTING_HEADER_ID MEASURE_DOCUMENT_ID, JA.DOCUMENT_NUMBER MEASURE_DOCUMENT_NUMBER, JA.JOINT_VENTURE_ID JOINT_VENTURE_ID, JV.JOINT_VENTURE_SHORT_NAME JOINT_VENTURE_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, GL_LEDGERS GL WHERE JV.JOINT_VENTURE_ID = JA.JOINT_VENTURE_ID AND GL.LEDGER_ID = JA.LEDGER_ID