JV_STAKEHOLDER_RPTG_LINE

Details

Schema: FUSION
Object owner: JV
Object type: VIEW

Columns

Name
LINE_NUMBER DISTRIBUTION_ID STAKEHOLDER_ID STAKEHOLDER_SHORT_NAME DISTRIBUTION_TYPE_CODE DISTRIBUTION_LINE_TYPE_CODE DISTRIBUTED_ACCOUNTED_AMOUNT CURRENCY_CODE EVENT_ID TRANSACTION_ID TRANSACTION_DATE APPLICATION_ID TRANSACTION_DESCRIPTION TRANSACTION_ACCOUNT PROJECT_ID TASK_ID EXPENDITURE_TYPE_ID EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ITEM_DATE EXPENDITURE_BU_ID

Name

LINE_NUMBER

DISTRIBUTION_ID

STAKEHOLDER_ID

STAKEHOLDER_SHORT_NAME

DISTRIBUTION_TYPE_CODE

DISTRIBUTION_LINE_TYPE_CODE

DISTRIBUTED_ACCOUNTED_AMOUNT

CURRENCY_CODE

EVENT_ID

TRANSACTION_ID

TRANSACTION_DATE

APPLICATION_ID

TRANSACTION_DESCRIPTION

TRANSACTION_ACCOUNT

PROJECT_ID

TASK_ID

EXPENDITURE_TYPE_ID

EXPENDITURE_ORGANIZATION_ID

EXPENDITURE_ITEM_DATE

EXPENDITURE_BU_ID

Query

SQL_Statement
SELECT JD.DISTRIBUTION_ID LINE_NUMBER, JD.DISTRIBUTION_ID DISTRIBUTION_ID, JD.STAKEHOLDER_ID STAKEHOLDER_ID, SH.STAKEHOLDER_SHORT_NAME STAKEHOLDER_SHORT_NAME, JD.DISTRIBUTION_TYPE_CODE DISTRIBUTION_TYPE_CODE, JD.DISTRIBUTION_LINE_TYPE_CODE DISTRIBUTION_LINE_TYPE_CODE, NVL(JD.DISTRIBUTED_DEBIT_AMOUNT, 0) - NVL(JD.DISTRIBUTED_CREDIT_AMOUNT, 0) DISTRIBUTED_ACCOUNTED_AMOUNT, JD.CURRENCY_CODE CURRENCY_CODE, JA.EVENT_ID EVENT_ID, JT.TRANSACTION_ID TRANSACTION_ID, JT.TRANSACTION_DATE TRANSACTION_DATE, JT.APPLICATION_ID APPLICATION_ID, JT.TRANSACTION_DESCRIPTION TRANSACTION_DESCRIPTION, JT.CODE_COMBINATION_ID TRANSACTION_ACCOUNT, JT.PROJECT_ID PROJECT_ID, JT.TASK_ID TASK_ID, JT.EXPENDITURE_TYPE_ID EXPENDITURE_TYPE_ID, JT.EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, JT.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, JT.EXPENDITURE_BU_ID EXPENDITURE_BU_ID FROM JV_DISTRIBUTIONS JD, JV_STAKEHOLDERS_B SH, JV_TRANSACTIONS JT, JV_ACCOUNTING_HEADERS JA WHERE JT.TRANSACTION_ID = JD.TRANSACTION_ID AND SH.STAKEHOLDER_ID = JD.STAKEHOLDER_ID AND JA.ACCOUNTING_HEADER_ID = JD.STAKEHOLDER_RPTG_HEADER_ID AND JT.APPLICATION_ID != -10568

SQL_Statement

SELECT

JD.DISTRIBUTION_ID LINE_NUMBER,

JD.DISTRIBUTION_ID DISTRIBUTION_ID,

JD.STAKEHOLDER_ID STAKEHOLDER_ID,

SH.STAKEHOLDER_SHORT_NAME STAKEHOLDER_SHORT_NAME,

JD.DISTRIBUTION_TYPE_CODE DISTRIBUTION_TYPE_CODE,

JD.DISTRIBUTION_LINE_TYPE_CODE DISTRIBUTION_LINE_TYPE_CODE,

NVL(JD.DISTRIBUTED_DEBIT_AMOUNT, 0) - NVL(JD.DISTRIBUTED_CREDIT_AMOUNT, 0)

DISTRIBUTED_ACCOUNTED_AMOUNT,

JD.CURRENCY_CODE CURRENCY_CODE,

JA.EVENT_ID EVENT_ID,

JT.TRANSACTION_ID TRANSACTION_ID,

JT.TRANSACTION_DATE TRANSACTION_DATE,

JT.APPLICATION_ID APPLICATION_ID,

JT.TRANSACTION_DESCRIPTION TRANSACTION_DESCRIPTION,

JT.CODE_COMBINATION_ID TRANSACTION_ACCOUNT,

JT.PROJECT_ID PROJECT_ID,

JT.TASK_ID TASK_ID,

JT.EXPENDITURE_TYPE_ID EXPENDITURE_TYPE_ID,

JT.EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID,

JT.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE,

JT.EXPENDITURE_BU_ID EXPENDITURE_BU_ID

FROM

JV_DISTRIBUTIONS JD,

JV_STAKEHOLDERS_B SH,

JV_TRANSACTIONS JT,

JV_ACCOUNTING_HEADERS JA

WHERE

JT.TRANSACTION_ID = JD.TRANSACTION_ID AND

SH.STAKEHOLDER_ID = JD.STAKEHOLDER_ID AND

JA.ACCOUNTING_HEADER_ID = JD.STAKEHOLDER_RPTG_HEADER_ID AND

JT.APPLICATION_ID != -10568