View: PA_PROJ_TRANSFERS_VIEW

Product:	PA - Projects
Description:	View of transferred expenditure items.
Implementation/DBA Data:	APPS.PA_PROJ_TRANSFERS_VIEW

View Text

SELECT P1.PROJECT_ID
, P1.SEGMENT1
, P1.NAME
, T1.TASK_ID
, T1.TASK_NUMBER
, T1.TASK_NAME
, EI.EXPENDITURE_ITEM_ID
, P2.PROJECT_ID
, P2.SEGMENT1
, P2.NAME
, T2.TASK_ID
, T2.TASK_NAME
, T2.TASK_NUMBER
, EI.TRANSFERRED_FROM_EXP_ITEM_ID
, E.INCURRED_BY_PERSON_ID
, NVL(PER.EMPLOYEE_NUMBER
, PER.NPW_NUMBER)
, PER.FULL_NAME
, E.INCURRED_BY_ORGANIZATION_ID
, ORGTL.NAME
, EI.EXPENDITURE_TYPE
, EI.EXPENDITURE_ITEM_DATE
, EI.QUANTITY
, LK.MEANING
, EI.RAW_COST
, EI.BURDEN_COST
, NVL(EI.ADJUSTED_REVENUE
, EI.RAW_REVENUE)
, EI.ACCRUED_REVENUE
, EI.DENOM_CURRENCY_CODE
, EI.DENOM_RAW_COST
, EI.DENOM_BURDENED_COST
, EI.ACCT_CURRENCY_CODE
, EI.ACCT_RATE_DATE
, EI.ACCT_RATE_TYPE
, EI.ACCT_EXCHANGE_RATE
, EI.ACCT_RAW_COST
, EI.ACCT_BURDENED_COST
, EI.PROJECT_CURRENCY_CODE
, EI.PROJECT_RATE_DATE
, EI.PROJECT_RATE_TYPE
, EI.PROJECT_EXCHANGE_RATE
, P1.ORG_ID
FROM PA_PROJECTS P1
, PA_TASKS T1
, PA_EXPENDITURE_ITEMS_ALL EI
, PA_EXPENDITURES_ALL E
, PA_EXPENDITURE_TYPES ET
, PA_LOOKUPS LK
, PA_EXPENDITURE_ITEMS_ALL EI2
, PA_TASKS T2
, PA_PROJECTS_ALL P2
, HR_ORG_UNITS_NO_JOIN ORG
, HR_ALL_ORGANIZATION_UNITS_TL ORGTL
, PER_PEOPLE_F PER
WHERE P1.PROJECT_ID = T1.PROJECT_ID
AND T1.TASK_ID = EI.TASK_ID
AND EI.EXPENDITURE_ID = E.EXPENDITURE_ID
AND EI.EXPENDITURE_TYPE = ET.EXPENDITURE_TYPE
AND E.INCURRED_BY_PERSON_ID = PER.PERSON_ID (+)
AND TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE (+)
AND PER.EFFECTIVE_END_DATE (+)
AND E.INCURRED_BY_ORGANIZATION_ID = ORG.ORGANIZATION_ID (+)
AND ORG.ORGANIZATION_ID = ORGTL.ORGANIZATION_ID(+)
AND DECODE(ORGTL.ORGANIZATION_ID
, NULL
, '1'
, ORGTL.LANGUAGE) = DECODE(ORGTL.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND EI.TRANSFERRED_FROM_EXP_ITEM_ID = EI2.EXPENDITURE_ITEM_ID
AND EI2.TASK_ID = T2.TASK_ID
AND T2.PROJECT_ID = P2.PROJECT_ID
AND NVL(EI.UNIT_OF_MEASURE
, ET.UNIT_OF_MEASURE) = LK.LOOKUP_CODE
AND LK.LOOKUP_TYPE = 'UNIT'

Columns