JV_STAKEHOLDER_RPTG_LINE_VL

Details

• Schema: FUSION

• Object owner: JV

• Object type: VIEW

Columns

Name
LINE_NUMBER LANGUAGE EVENT_ID STAKEHOLDER_NAME PROJECT_NAME TASK_NAME EXPENDITURE_TYPE_NAME EXPENDITURE_ORGANIZATION_NAME EXPENDITURE_BU_NAME

Query

SQL_Statement

SELECT JD.DISTRIBUTION_ID LINE_NUMBER, SH.LANGUAGE LANGUAGE, JA.EVENT_ID EVENT_ID, SH.STAKEHOLDER_NAME STAKEHOLDER_NAME, PR.NAME PROJECT_NAME, PE.NAME TASK_NAME, ET.EXPENDITURE_TYPE_NAME EXPENDITURE_TYPE_NAME, OU.NAME EXPENDITURE_ORGANIZATION_NAME, BU.NAME EXPENDITURE_BU_NAME FROM JV_DISTRIBUTIONS JD, JV_TRANSACTIONS JT, JV_ACCOUNTING_HEADERS JA, JV_STAKEHOLDERS_TL SH, PJF_PROJECTS_ALL_TL PR, PJF_PROJ_ELEMENTS_TL PE, PJF_EXP_TYPES_TL ET, HR_ORGANIZATION_UNITS_F_TL OU, HR_ORGANIZATION_UNITS_F_TL BU WHERE JT.TRANSACTION_ID = JD.TRANSACTION_ID AND JA.ACCOUNTING_HEADER_ID = JD.STAKEHOLDER_RPTG_HEADER_ID AND SH.STAKEHOLDER_ID = JD.STAKEHOLDER_ID AND PR.PROJECT_ID(+) = JT.PROJECT_ID AND PR.LANGUAGE(+) = SH.LANGUAGE AND PE.PROJ_ELEMENT_ID(+) = JT.TASK_ID AND PE.LANGUAGE(+) = SH.LANGUAGE AND ET.EXPENDITURE_TYPE_ID(+) = JT.EXPENDITURE_TYPE_ID AND ET.LANGUAGE(+) = SH.LANGUAGE AND OU.ORGANIZATION_ID(+) = JT.EXPENDITURE_ORGANIZATION_ID AND (TRUNC(SYSDATE) BETWEEN OU.EFFECTIVE_START_DATE AND OU.EFFECTIVE_END_DATE OR JT.EXPENDITURE_ORGANIZATION_ID IS NULL) AND OU.LANGUAGE(+) = SH.LANGUAGE AND BU.ORGANIZATION_ID(+) = JT. EXPENDITURE_BU_ID AND (TRUNC(SYSDATE) BETWEEN BU.EFFECTIVE_START_DATE AND BU.EFFECTIVE_END_DATE OR JT.EXPENDITURE_BU_ID IS NULL) AND BU.LANGUAGE(+) = SH.LANGUAGE