1. Tables and Views for Financials
  2. JV_INTERNAL_TRANSFER_INFO_V

JV_INTERNAL_TRANSFER_INFO_V

Details

  • Schema: FUSION

  • Object owner: JV

  • Object type: VIEW

Columns

Name

TRANSFER_DOCUMENT_ID

JOINT_VENTURE_SHORT_NAME

STAKEHOLDER_SHORT_NAME

TRANSFER_DOCUMENT_NUMBER

Query

SQL_Statement

SELECT JA.ACCOUNTING_HEADER_ID TRANSFER_DOCUMENT_ID,

JV.JOINT_VENTURE_SHORT_NAME JOINT_VENTURE_SHORT_NAME,

SH.STAKEHOLDER_SHORT_NAME STAKEHOLDER_SHORT_NAME,

JA.DOCUMENT_NUMBER TRANSFER_DOCUMENT_NUMBER

FROM JV_ACCOUNTING_HEADERS JA,

JV_JOINT_VENTURES_B JV,

JV_STAKEHOLDERS_B SH

WHERE

JV.JOINT_VENTURE_ID = JA.JOINT_VENTURE_ID AND

SH.STAKEHOLDER_ID = JA.STAKEHOLDER_ID