JV_INTERNAL_TRANSFER_HEADER_V

Details

• Schema: FUSION

• Object owner: JV

• Object type: VIEW

Columns

Name
TRANSFER_DOCUMENT_ID TRANSFER_DOCUMENT_NUMBER JOINT_VENTURE_ID JOINT_VENTURE_SHORT_NAME STAKEHOLDER_ID STAKEHOLDER_SHORT_NAME PRIMARY_SEGMENT_VALUE ACCOUNTING_DATE EVENT_ID LEDGER_NAME

Query

SQL_Statement

SELECT JA.ACCOUNTING_HEADER_ID TRANSFER_DOCUMENT_ID, JA.DOCUMENT_NUMBER TRANSFER_DOCUMENT_NUMBER, JA.JOINT_VENTURE_ID JOINT_VENTURE_ID, JV.JOINT_VENTURE_SHORT_NAME JOINT_VENTURE_SHORT_NAME, JA.STAKEHOLDER_ID STAKEHOLDER_ID, SH.STAKEHOLDER_SHORT_NAME STAKEHOLDER_SHORT_NAME, SH.COST_CENTER_SEGMENT_VALUE PRIMARY_SEGMENT_VALUE, 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_STAKEHOLDERS_B SH, GL_LEDGERS GL WHERE JV.JOINT_VENTURE_ID = JA.JOINT_VENTURE_ID AND SH.STAKEHOLDER_ID = JA.STAKEHOLDER_ID AND GL.LEDGER_ID = JA.LEDGER_ID