View: PA_FP_VP_TXNCURRENCY_V

Product:	PA - Projects
Description:	This view is used for the View Plans page. It retrieves user-entered budget lines
Implementation/DBA Data:	APPS.PA_FP_VP_TXNCURRENCY_V

View Text

SELECT DECODE(TASK_SEQUENCE_ID || '.' || RESOURCE_GROUP_ID || '.' || RESOURCE_ID || '.' || TXN_CURRENCY_CODE
, LEVEL2
, PA_FP_VIEW_PLANS_TXN_PUB.GET_TASK_NAME(TASK_ID) || ' (' || PA_FP_VIEW_PLANS_TXN_PUB.GET_TASK_NUMBER(TASK_ID) || ')'
, NULL) TASK_NAME
, DECODE(RESOURCE_GROUP_ID || '.' || RESOURCE_ID || '.' || TXN_CURRENCY_CODE
, LEVEL3
, RESOURCE_GROUP_NAME
, NULL) RESOURCE_GROUP_NAME
, DECODE(RESOURCE_ID || '.' || TXN_CURRENCY_CODE
, LEVEL4
, RESOURCE_NAME
, NULL) RESOURCE_NAME
, TASK_ID
, COST_RESOURCE_ASSIGNMENT_ID
, REV_RESOURCE_ASSIGNMENT_ID
, ALL_RESOURCE_ASSIGNMENT_ID
, TXN_CURRENCY_CODE
, UNIT_OF_MEASURE
, QUANTITY
, BURDENED_COST
, RAW_COST
, REVENUE
, MARGIN
, MARGIN_PERCENT
FROM (SELECT PROJECT_ID
, TASK_SEQUENCE_ID
, RESOURCE_GROUP_ID
, RESOURCE_ID
, TXN_CURRENCY_CODE
, FIRST_VALUE(PROJECT_ID || '.' || TASK_SEQUENCE_ID || '.' || RESOURCE_GROUP_ID || '.' || RESOURCE_ID || '.' || TXN_CURRENCY_CODE) OVER (PARTITION BY PROJECT_ID ORDER BY TASK_SEQUENCE_ID
, RESOURCE_GROUP_ID
, RESOURCE_ID
, TXN_CURRENCY_CODE) LEVEL1
, FIRST_VALUE(TASK_SEQUENCE_ID || '.' || RESOURCE_GROUP_ID || '.' || RESOURCE_ID || '.' || TXN_CURRENCY_CODE) OVER (PARTITION BY PROJECT_ID
, TASK_SEQUENCE_ID ORDER BY RESOURCE_GROUP_ID
, RESOURCE_ID
, TXN_CURRENCY_CODE) LEVEL2
, FIRST_VALUE(RESOURCE_GROUP_ID || '.' || RESOURCE_ID || '.' || TXN_CURRENCY_CODE) OVER (PARTITION BY PROJECT_ID
, TASK_ID
, RESOURCE_GROUP_ID ORDER BY RESOURCE_ID
, TXN_CURRENCY_CODE) LEVEL3
, FIRST_VALUE(RESOURCE_ID || '.' || TXN_CURRENCY_CODE) OVER (PARTITION BY PROJECT_ID
, TASK_ID
, RESOURCE_GROUP_ID
, RESOURCE_ID ORDER BY TXN_CURRENCY_CODE) LEVEL4
, TASK_ID
, COST_RESOURCE_ASSIGNMENT_ID
, REV_RESOURCE_ASSIGNMENT_ID
, ALL_RESOURCE_ASSIGNMENT_ID
, RESOURCE_GROUP_NAME
, RESOURCE_NAME
, UNIT_OF_MEASURE
, QUANTITY
, BURDENED_COST
, RAW_COST
, REVENUE
, MARGIN
, MARGIN_PERCENT
FROM (SELECT D.PROJECT_ID
, D.TASK_ID
, PA_PROJ_ELEMENTS_UTILS.GET_DISPLAY_SEQUENCE(TASK_ID) AS TASK_SEQUENCE_ID
, DECODE(RLM.PARENT_MEMBER_ID
, NULL
, DECODE(D.GROUPING_TYPE
, 'NONGROUPED'
, NULL
, RLM.RESOURCE_ID)
, RLM2.RESOURCE_ID) AS RESOURCE_GROUP_ID
, DECODE(RLM.PARENT_MEMBER_ID
, NULL
, DECODE(D.GROUPING_TYPE
, 'NONGROUPED'
, NULL
, RLM.ALIAS)
, RLM2.ALIAS) AS RESOURCE_GROUP_NAME
, DECODE(RLM.PARENT_MEMBER_ID
, NULL
, DECODE(D.GROUPING_TYPE
, 'NONGROUPED'
, RLM.RESOURCE_ID
, NULL)
, RLM.RESOURCE_ID) AS RESOURCE_ID
, DECODE(RLM.PARENT_MEMBER_ID
, NULL
, DECODE(D.GROUPING_TYPE
, 'NONGROUPED'
, RLM.ALIAS
, NULL)
, RLM.ALIAS) AS RESOURCE_NAME
, D.COST_RESOURCE_ASSIGNMENT_ID
, D.REV_RESOURCE_ASSIGNMENT_ID
, D.ALL_RESOURCE_ASSIGNMENT_ID
, D.TXN_CURRENCY_CODE AS TXN_CURRENCY_CODE
, D.UNIT_OF_MEASURE
, D.QUANTITY AS QUANTITY
, D.BURDENED_COST AS BURDENED_COST
, D.RAW_COST AS RAW_COST
, D.REVENUE AS REVENUE
, D.MARGIN AS MARGIN
, D.MARGIN_PCT AS MARGIN_PERCENT
FROM PA_FP_TXN_LINES_TMP D
, PA_RESOURCE_LIST_MEMBERS RLM
, PA_RESOURCE_LIST_MEMBERS RLM2
WHERE D.RESOURCE_LIST_MEMBER_ID = RLM.RESOURCE_LIST_MEMBER_ID
AND RLM.PARENT_MEMBER_ID = RLM2.RESOURCE_LIST_MEMBER_ID (+) ORDER BY PROJECT_ID
, TASK_SEQUENCE_ID
, RESOURCE_GROUP_NAME
, RESOURCE_NAME
, RESOURCE_ID
, TXN_CURRENCY_CODE) )

Columns