JV_CI_JOURNAL_LINE_VL

Details

• Schema: FUSION

• Object owner: JV

• Object type: VIEW

Columns

Name
LINE_NUMBER LANGUAGE EVENT_ID CS_STAKEHOLDER_NAME NCS_STAKEHOLDER_NAME PROJECT_NAME TASK_NAME EXPENDITURE_TYPE_NAME EXPENDITURE_ORGANIZATION_NAME

Query

SQL_Statement

SELECT CI.CI_DISTRIBUTION_ID LINE_NUMBER, CS.LANGUAGE LANGUAGE, JA.EVENT_ID EVENT_ID, CS.STAKEHOLDER_NAME CS_STAKEHOLDER_NAME, NS.STAKEHOLDER_NAME NCS_STAKEHOLDER_NAME, PR.NAME PROJECT_NAME, PE.NAME TASK_NAME, ET.EXPENDITURE_TYPE_NAME EXPENDITURE_TYPE_NAME, OU.NAME EXPENDITURE_ORGANIZATION_NAME FROM JV_CI_DISTRIBUTIONS CI, JV_TRANSACTIONS JT, JV_ACCOUNTING_HEADERS JA, PJF_PROJECTS_ALL_TL PR, PJF_PROJ_ELEMENTS_TL PE, PJF_EXP_TYPES_TL ET, HR_ORGANIZATION_UNITS_F_TL OU, JV_STAKEHOLDERS_TL CS, JV_STAKEHOLDERS_TL NS WHERE JT.TRANSACTION_ID = CI.TRANSACTION_ID AND JA.ACCOUNTING_HEADER_ID = CI.ACCOUNTING_HEADER_ID AND CS.STAKEHOLDER_ID = CI.CONSENTING_STAKEHOLDER_ID AND NS.STAKEHOLDER_ID = CI.NON_CONSENTING_STAKEHOLDER_ID AND NS.LANGUAGE = CS.LANGUAGE AND PR.PROJECT_ID(+) = JT.PROJECT_ID AND PR.LANGUAGE(+) = CS.LANGUAGE AND PE.PROJ_ELEMENT_ID(+) = JT.TASK_ID AND PE.LANGUAGE(+) = CS.LANGUAGE AND ET.EXPENDITURE_TYPE_ID(+) = JT.EXPENDITURE_TYPE_ID AND ET.LANGUAGE(+) = CS.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(+) = CS.LANGUAGE