1. Tables and Views for Financials
  2. JV_STAKEHOLDER_RPTG_LINE_V

JV_STAKEHOLDER_RPTG_LINE_V

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

TRANSACTION_ACCOUNT_SEG1

TRANSACTION_ACCOUNT_SEG2

TRANSACTION_ACCOUNT_SEG3

TRANSACTION_ACCOUNT_SEG4

TRANSACTION_ACCOUNT_SEG5

TRANSACTION_ACCOUNT_SEG6

TRANSACTION_ACCOUNT_SEG7

TRANSACTION_ACCOUNT_SEG8

TRANSACTION_ACCOUNT_SEG9

TRANSACTION_ACCOUNT_SEG10

TRANSACTION_ACCOUNT_SEG11

TRANSACTION_ACCOUNT_SEG12

TRANSACTION_ACCOUNT_SEG13

TRANSACTION_ACCOUNT_SEG14

TRANSACTION_ACCOUNT_SEG15

TRANSACTION_ACCOUNT_SEG16

TRANSACTION_ACCOUNT_SEG17

TRANSACTION_ACCOUNT_SEG18

TRANSACTION_ACCOUNT_SEG19

TRANSACTION_ACCOUNT_SEG20

TRANSACTION_ACCOUNT_SEG21

TRANSACTION_ACCOUNT_SEG22

TRANSACTION_ACCOUNT_SEG23

TRANSACTION_ACCOUNT_SEG24

TRANSACTION_ACCOUNT_SEG25

TRANSACTION_ACCOUNT_SEG26

TRANSACTION_ACCOUNT_SEG27

TRANSACTION_ACCOUNT_SEG28

TRANSACTION_ACCOUNT_SEG29

TRANSACTION_ACCOUNT_SEG30

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,

GC.SEGMENT1 TRANSACTION_ACCOUNT_SEG1,

GC.SEGMENT2 TRANSACTION_ACCOUNT_SEG2,

GC.SEGMENT3 TRANSACTION_ACCOUNT_SEG3,

GC.SEGMENT4 TRANSACTION_ACCOUNT_SEG4,

GC.SEGMENT5 TRANSACTION_ACCOUNT_SEG5,

GC.SEGMENT6 TRANSACTION_ACCOUNT_SEG6,

GC.SEGMENT7 TRANSACTION_ACCOUNT_SEG7,

GC.SEGMENT8 TRANSACTION_ACCOUNT_SEG8,

GC.SEGMENT9 TRANSACTION_ACCOUNT_SEG9,

GC.SEGMENT10 TRANSACTION_ACCOUNT_SEG10,

GC.SEGMENT11 TRANSACTION_ACCOUNT_SEG11,

GC.SEGMENT12 TRANSACTION_ACCOUNT_SEG12,

GC.SEGMENT13 TRANSACTION_ACCOUNT_SEG13,

GC.SEGMENT14 TRANSACTION_ACCOUNT_SEG14,

GC.SEGMENT15 TRANSACTION_ACCOUNT_SEG15,

GC.SEGMENT16 TRANSACTION_ACCOUNT_SEG16,

GC.SEGMENT17 TRANSACTION_ACCOUNT_SEG17,

GC.SEGMENT18 TRANSACTION_ACCOUNT_SEG18,

GC.SEGMENT19 TRANSACTION_ACCOUNT_SEG19,

GC.SEGMENT20 TRANSACTION_ACCOUNT_SEG20,

GC.SEGMENT21 TRANSACTION_ACCOUNT_SEG21,

GC.SEGMENT22 TRANSACTION_ACCOUNT_SEG22,

GC.SEGMENT23 TRANSACTION_ACCOUNT_SEG23,

GC.SEGMENT24 TRANSACTION_ACCOUNT_SEG24,

GC.SEGMENT25 TRANSACTION_ACCOUNT_SEG25,

GC.SEGMENT26 TRANSACTION_ACCOUNT_SEG26,

GC.SEGMENT27 TRANSACTION_ACCOUNT_SEG27,

GC.SEGMENT28 TRANSACTION_ACCOUNT_SEG28,

GC.SEGMENT29 TRANSACTION_ACCOUNT_SEG29,

GC.SEGMENT30 TRANSACTION_ACCOUNT_SEG30,

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,

GL_CODE_COMBINATIONS GC

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

GC.CODE_COMBINATION_ID = JT.CODE_COMBINATION_ID AND

JT.APPLICATION_ID != -10568