JV_INTERNAL_TRANSFER_LINE_VL

Details

• Schema: FUSION

• Object owner: JV

• Object type: VIEW

Columns

Name
LINE_NUMBER LANGUAGE EVENT_ID PROJECT_NAME TASK_NAME EXPENDITURE_TYPE_NAME EXPENDITURE_ORGANIZATION_NAME

Query

SQL_Statement

SELECT JD.DISTRIBUTION_ID LINE_NUMBER, PR.LANGUAGE LANGUAGE, JA.EVENT_ID EVENT_ID, PR.NAME PROJECT_NAME, PE.NAME TASK_NAME, ET.EXPENDITURE_TYPE_NAME EXPENDITURE_TYPE_NAME, OU.NAME EXPENDITURE_ORGANIZATION_NAME FROM JV_DISTRIBUTIONS JD, 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 WHERE JT.TRANSACTION_ID = JD.TRANSACTION_ID AND JA.ACCOUNTING_HEADER_ID = JD.TARGET_TRANSACTION_ID AND PR.PROJECT_ID(+) = JT.PROJECT_ID AND PE.PROJ_ELEMENT_ID(+) = JT.TASK_ID AND PE.LANGUAGE(+) = PR.LANGUAGE AND ET.EXPENDITURE_TYPE_ID(+) = JT.EXPENDITURE_TYPE_ID AND ET.LANGUAGE(+) = PR.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(+) = PR.LANGUAGE