JV_PC_JOURNAL_LINE

Details

Schema: FUSION
Object owner: JV
Object type: VIEW

Columns

Name
EVENT_ID FROM_CONTRIBUTION_REFERENCE_ID LINE_NUMBER FROM_CONTRIBUTION_ID FROM_COST_CENTER_SEGMENT_VALUE TRANSACTION_AMOUNT FROM_PREFERRED_CURRENCY_CODE FROM_CONTRIBUTION_ACCOUNT AGREEMENT_DEFAULT_AMOUNT AGREEMENT_DEFAULT_ACCT REFUND_AMOUNT TO_CONTRIBUTION_ID TO_JOINT_VENTURE_ID TO_JOINT_VENTURE_SHORT_NAME TO_STAKEHOLDER_ID TO_STAKEHOLDER_SHORT_NAME TO_COST_CENTER_SEGMENT_VALUE TO_PREFERRED_CURRENCY_CODE TO_CONTRIBUTION_ACCOUNT TO_START_DATE TO_SEQUENCE_NUMBER

Name

EVENT_ID

FROM_CONTRIBUTION_REFERENCE_ID

LINE_NUMBER

FROM_CONTRIBUTION_ID

FROM_COST_CENTER_SEGMENT_VALUE

TRANSACTION_AMOUNT

FROM_PREFERRED_CURRENCY_CODE

FROM_CONTRIBUTION_ACCOUNT

AGREEMENT_DEFAULT_AMOUNT

AGREEMENT_DEFAULT_ACCT

REFUND_AMOUNT

TO_CONTRIBUTION_ID

TO_JOINT_VENTURE_ID

TO_JOINT_VENTURE_SHORT_NAME

TO_STAKEHOLDER_ID

TO_STAKEHOLDER_SHORT_NAME

TO_COST_CENTER_SEGMENT_VALUE

TO_PREFERRED_CURRENCY_CODE

TO_CONTRIBUTION_ACCOUNT

TO_START_DATE

TO_SEQUENCE_NUMBER

Query

SQL_Statement
SELECT JA.EVENT_ID EVENT_ID, FROM_CR.CONTRIBUTION_REFERENCE_ID FROM_CONTRIBUTION_REFERENCE_ID, FROM_CR.CONTRIBUTION_REFERENCE_ID LINE_NUMBER, FROM_PC.CONTRIBUTION_ID FROM_CONTRIBUTION_ID, FROM_SH.COST_CENTER_SEGMENT_VALUE FROM_COST_CENTER_SEGMENT_VALUE, FROM_PC.CONTRIBUTION_OPEN_AMOUNT TRANSACTION_AMOUNT, GL.CURRENCY_CODE FROM_PREFERRED_CURRENCY_CODE, FROM_PC.PARTNER_ACCOUNT_CCID FROM_CONTRIBUTION_ACCOUNT, CASE WHEN (FROM_CR.AGREEMENT_DEFAULT_AMOUNT = 0) THEN CAST(NULL AS NUMBER) ELSE FROM_CR.AGREEMENT_DEFAULT_AMOUNT END AGREEMENT_DEFAULT_AMOUNT, FROM_CR.AGREEMENT_DEFAULT_CCID AGREEMENT_DEFAULT_ACCT, FROM_CR.REFUND_AMOUNT REFUND_AMOUNT, TO_PC.CONTRIBUTION_ID TO_CONTRIBUTION_ID, TO_JV.JOINT_VENTURE_ID TO_JOINT_VENTURE_ID, TO_JV.JOINT_VENTURE_SHORT_NAME TO_JOINT_VENTURE_SHORT_NAME, TO_SH.STAKEHOLDER_ID TO_STAKEHOLDER_ID, TO_SH.STAKEHOLDER_SHORT_NAME TO_STAKEHOLDER_SHORT_NAME, TO_SH.COST_CENTER_SEGMENT_VALUE TO_COST_CENTER_SEGMENT_VALUE, TO_PC.PREFERRED_CURRENCY_CODE TO_PREFERRED_CURRENCY_CODE, TO_PC.PARTNER_ACCOUNT_CCID TO_CONTRIBUTION_ACCOUNT, TO_PC.START_DATE TO_START_DATE, TO_PC.SEQUENCE_NUMBER TO_SEQUENCE_NUMBER FROM JV_ACCOUNTING_HEADERS JA, JV_CONTRIBUTION_REFERENCES FROM_CR, JV_CONTRIBUTIONS_B FROM_PC, JV_STAKEHOLDERS_B FROM_SH, JV_JOINT_VENTURES_B TO_JV, JV_CONTRIBUTIONS_B TO_PC, JV_STAKEHOLDERS_B TO_SH, GL_LEDGERS GL WHERE FROM_PC.CONTRIBUTION_ID = JA.CONTRIBUTION_ID AND FROM_CR.CONTRIBUTION_ID = FROM_PC.CONTRIBUTION_ID AND FROM_CR.TRANSACTION_ID = JA.ACCOUNTING_HEADER_ID AND FROM_SH.STAKEHOLDER_ID = FROM_PC.STAKEHOLDER_ID AND GL.LEDGER_ID = JA.LEDGER_ID AND TO_PC.CONTRIBUTION_ID(+) = FROM_CR.RELATED_CONTRIBUTION_ID AND TO_JV.JOINT_VENTURE_ID(+) = TO_PC.JOINT_VENTURE_ID AND TO_SH.STAKEHOLDER_ID(+) = TO_PC.STAKEHOLDER_ID

SQL_Statement

SELECT

JA.EVENT_ID EVENT_ID,

FROM_CR.CONTRIBUTION_REFERENCE_ID FROM_CONTRIBUTION_REFERENCE_ID,

FROM_CR.CONTRIBUTION_REFERENCE_ID LINE_NUMBER,

FROM_PC.CONTRIBUTION_ID FROM_CONTRIBUTION_ID,

FROM_SH.COST_CENTER_SEGMENT_VALUE FROM_COST_CENTER_SEGMENT_VALUE,

FROM_PC.CONTRIBUTION_OPEN_AMOUNT TRANSACTION_AMOUNT,

GL.CURRENCY_CODE FROM_PREFERRED_CURRENCY_CODE,

FROM_PC.PARTNER_ACCOUNT_CCID FROM_CONTRIBUTION_ACCOUNT,

CASE WHEN (FROM_CR.AGREEMENT_DEFAULT_AMOUNT = 0) THEN CAST(NULL AS NUMBER)

ELSE FROM_CR.AGREEMENT_DEFAULT_AMOUNT

END AGREEMENT_DEFAULT_AMOUNT,

FROM_CR.AGREEMENT_DEFAULT_CCID AGREEMENT_DEFAULT_ACCT,

FROM_CR.REFUND_AMOUNT REFUND_AMOUNT,

TO_PC.CONTRIBUTION_ID TO_CONTRIBUTION_ID,

TO_JV.JOINT_VENTURE_ID TO_JOINT_VENTURE_ID,

TO_JV.JOINT_VENTURE_SHORT_NAME TO_JOINT_VENTURE_SHORT_NAME,

TO_SH.STAKEHOLDER_ID TO_STAKEHOLDER_ID,

TO_SH.STAKEHOLDER_SHORT_NAME TO_STAKEHOLDER_SHORT_NAME,

TO_SH.COST_CENTER_SEGMENT_VALUE TO_COST_CENTER_SEGMENT_VALUE,

TO_PC.PREFERRED_CURRENCY_CODE TO_PREFERRED_CURRENCY_CODE,

TO_PC.PARTNER_ACCOUNT_CCID TO_CONTRIBUTION_ACCOUNT,

TO_PC.START_DATE TO_START_DATE,

TO_PC.SEQUENCE_NUMBER TO_SEQUENCE_NUMBER

FROM

JV_ACCOUNTING_HEADERS JA,

JV_CONTRIBUTION_REFERENCES FROM_CR,

JV_CONTRIBUTIONS_B FROM_PC,

JV_STAKEHOLDERS_B FROM_SH,

JV_JOINT_VENTURES_B TO_JV,

JV_CONTRIBUTIONS_B TO_PC,

JV_STAKEHOLDERS_B TO_SH,

GL_LEDGERS GL

WHERE

FROM_PC.CONTRIBUTION_ID = JA.CONTRIBUTION_ID AND

FROM_CR.CONTRIBUTION_ID = FROM_PC.CONTRIBUTION_ID AND

FROM_CR.TRANSACTION_ID = JA.ACCOUNTING_HEADER_ID AND

FROM_SH.STAKEHOLDER_ID = FROM_PC.STAKEHOLDER_ID AND

GL.LEDGER_ID = JA.LEDGER_ID AND

TO_PC.CONTRIBUTION_ID(+) = FROM_CR.RELATED_CONTRIBUTION_ID AND

TO_JV.JOINT_VENTURE_ID(+) = TO_PC.JOINT_VENTURE_ID AND

TO_SH.STAKEHOLDER_ID(+) = TO_PC.STAKEHOLDER_ID