View: PA_FP_BUDGET_LINE_REJECTIONS_V

Product:	PA - Projects
Description:	Resource Assignment level and Task assignment level rejection details for self service budgets and workplan.
Implementation/DBA Data:	APPS.PA_FP_BUDGET_LINE_REJECTIONS_V

View Text

SELECT BV.BUDGET_VERSION_ID
, BV.PROJECT_ID
, RAM.TASK_ID
, BL.BUDGET_LINE_ID
, BL.START_DATE
, BL.END_DATE
, BL.PERIOD_NAME
, BL.RESOURCE_ASSIGNMENT_ID
, BL.TXN_CURRENCY_CODE
, BL.PROJECT_CURRENCY_CODE
, BL.PROJFUNC_CURRENCY_CODE
, BL.COST_REJECTION_CODE
, (SELECT MESSAGE_TEXT
FROM FND_NEW_MESSAGES
WHERE MESSAGE_NAME = BL.COST_REJECTION_CODE
AND APPLICATION_ID = 275
AND LANGUAGE_CODE = USERENV('LANG') ) COST_REJECTION_MSG_DATA
, NVL((SELECT 'Y'
FROM DUAL WHERE EXISTS (SELECT NULL
FROM PA_BUDGET_LINES BL1 WHERE BL1.BUDGET_VERSION_ID = BV.BUDGET_VERSION_ID AND BL1.TXN_CURRENCY_CODE = BL.TXN_CURRENCY_CODE AND BL1.RESOURCE_ASSIGNMENT_ID = BL.RESOURCE_ASSIGNMENT_ID AND BL1.COST_REJECTION_CODE IS NOT NULL ))
, 'N') COST_REJECTION_FLAG
, NVL((SELECT 'Y'
FROM DUAL
WHERE EXISTS (SELECT NULL
FROM PA_BUDGET_LINES BL1
WHERE BL1.BUDGET_VERSION_ID = BV.BUDGET_VERSION_ID
AND BL1.TXN_CURRENCY_CODE = BL.TXN_CURRENCY_CODE
AND BL1.RESOURCE_ASSIGNMENT_ID = BL.RESOURCE_ASSIGNMENT_ID
AND BL1.START_DATE BETWEEN PA_FIN_PLAN_UTILS2.GET_BDGT_START_DATE
AND PA_FIN_PLAN_UTILS2.GET_BDGT_END_DATE
AND BL1.END_DATE BETWEEN PA_FIN_PLAN_UTILS2.GET_BDGT_START_DATE
AND PA_FIN_PLAN_UTILS2.GET_BDGT_END_DATE
AND BL1.COST_REJECTION_CODE IS NOT NULL ))
, 'N') PERIOD_COST_REJECTION_FLAG
, BL.BURDEN_REJECTION_CODE
, (SELECT MESSAGE_TEXT
FROM FND_NEW_MESSAGES
WHERE MESSAGE_NAME = BL.BURDEN_REJECTION_CODE
AND APPLICATION_ID = 275
AND LANGUAGE_CODE = USERENV('LANG') ) BURDEN_REJECTION_MSG_DATA
, NVL((SELECT 'Y'
FROM DUAL WHERE EXISTS (SELECT NULL
FROM PA_BUDGET_LINES BL1 WHERE BL1.BUDGET_VERSION_ID = BV.BUDGET_VERSION_ID AND BL1.TXN_CURRENCY_CODE = BL.TXN_CURRENCY_CODE AND BL1.RESOURCE_ASSIGNMENT_ID = BL.RESOURCE_ASSIGNMENT_ID AND BL1.BURDEN_REJECTION_CODE IS NOT NULL ))
, 'N') BURDEN_REJECTION_FLAG
, NVL((SELECT 'Y'
FROM DUAL
WHERE EXISTS (SELECT NULL
FROM PA_BUDGET_LINES BL1
WHERE BL1.BUDGET_VERSION_ID = BV.BUDGET_VERSION_ID
AND BL1.TXN_CURRENCY_CODE = BL.TXN_CURRENCY_CODE
AND BL1.RESOURCE_ASSIGNMENT_ID = BL.RESOURCE_ASSIGNMENT_ID
AND BL1.START_DATE BETWEEN PA_FIN_PLAN_UTILS2.GET_BDGT_START_DATE
AND PA_FIN_PLAN_UTILS2.GET_BDGT_END_DATE
AND BL1.END_DATE BETWEEN PA_FIN_PLAN_UTILS2.GET_BDGT_START_DATE
AND PA_FIN_PLAN_UTILS2.GET_BDGT_END_DATE
AND BL1.BURDEN_REJECTION_CODE IS NOT NULL ))
, 'N') PERIOD_BURDEN_REJECTION_FLAG
, BL.REVENUE_REJECTION_CODE
, (SELECT MESSAGE_TEXT
FROM FND_NEW_MESSAGES
WHERE MESSAGE_NAME = BL.REVENUE_REJECTION_CODE
AND APPLICATION_ID = 275
AND LANGUAGE_CODE = USERENV('LANG') ) REVENUE_REJECTION_MSG_DATA
, NVL((SELECT 'Y'
FROM DUAL WHERE EXISTS (SELECT NULL FROM PA_BUDGET_LINES BL1 WHERE BL1.BUDGET_VERSION_ID = BV.BUDGET_VERSION_ID AND BL1.TXN_CURRENCY_CODE = BL.TXN_CURRENCY_CODE AND BL1.RESOURCE_ASSIGNMENT_ID = BL.RESOURCE_ASSIGNMENT_ID AND BL1.REVENUE_REJECTION_CODE IS NOT NULL ))
, 'N') REVENUE_REJECTION_FLAG
, NVL((SELECT 'Y'
FROM DUAL
WHERE EXISTS (SELECT NULL
FROM PA_BUDGET_LINES BL1
WHERE BL1.BUDGET_VERSION_ID = BV.BUDGET_VERSION_ID
AND BL1.TXN_CURRENCY_CODE = BL.TXN_CURRENCY_CODE
AND BL1.RESOURCE_ASSIGNMENT_ID = BL.RESOURCE_ASSIGNMENT_ID
AND BL1.START_DATE BETWEEN PA_FIN_PLAN_UTILS2.GET_BDGT_START_DATE
AND PA_FIN_PLAN_UTILS2.GET_BDGT_END_DATE
AND BL1.END_DATE BETWEEN PA_FIN_PLAN_UTILS2.GET_BDGT_START_DATE
AND PA_FIN_PLAN_UTILS2.GET_BDGT_END_DATE
AND BL1.REVENUE_REJECTION_CODE IS NOT NULL ))
, 'N') PERIOD_REVENUE_REJECTION_FLAG
, BL.PC_CUR_CONV_REJECTION_CODE
, (SELECT MESSAGE_TEXT
FROM FND_NEW_MESSAGES
WHERE MESSAGE_NAME = BL.PC_CUR_CONV_REJECTION_CODE
AND APPLICATION_ID = 275
AND LANGUAGE_CODE = USERENV('LANG') ) PC_CONV_REJECTION_MSG_DATA
, NVL((SELECT 'Y'
FROM DUAL WHERE EXISTS (SELECT NULL FROM PA_BUDGET_LINES BL1 WHERE BL1.BUDGET_VERSION_ID = BV.BUDGET_VERSION_ID AND BL1.TXN_CURRENCY_CODE = BL.TXN_CURRENCY_CODE AND BL1.RESOURCE_ASSIGNMENT_ID = BL.RESOURCE_ASSIGNMENT_ID AND BL1.PC_CUR_CONV_REJECTION_CODE IS NOT NULL ))
, 'N') PC_CONV_REJECTION_FLAG
, NVL((SELECT 'Y'
FROM DUAL
WHERE EXISTS (SELECT NULL
FROM PA_BUDGET_LINES BL1
WHERE BL1.BUDGET_VERSION_ID = BV.BUDGET_VERSION_ID
AND BL1.TXN_CURRENCY_CODE = BL.TXN_CURRENCY_CODE
AND BL1.RESOURCE_ASSIGNMENT_ID = BL.RESOURCE_ASSIGNMENT_ID
AND BL1.START_DATE BETWEEN PA_FIN_PLAN_UTILS2.GET_BDGT_START_DATE
AND PA_FIN_PLAN_UTILS2.GET_BDGT_END_DATE
AND BL1.END_DATE BETWEEN PA_FIN_PLAN_UTILS2.GET_BDGT_START_DATE
AND PA_FIN_PLAN_UTILS2.GET_BDGT_END_DATE
AND BL1.PC_CUR_CONV_REJECTION_CODE IS NOT NULL ))
, 'N') PERIOD_PC_CONV_REJECTION_FLAG
, BL.PFC_CUR_CONV_REJECTION_CODE
, (SELECT MESSAGE_TEXT
FROM FND_NEW_MESSAGES
WHERE MESSAGE_NAME = BL.PFC_CUR_CONV_REJECTION_CODE
AND APPLICATION_ID = 275
AND LANGUAGE_CODE = USERENV('LANG') ) PFC_CONV_REJECTION_MSG_DATA
, NVL((SELECT 'Y'
FROM DUAL WHERE EXISTS (SELECT NULL FROM PA_BUDGET_LINES BL1 WHERE BL1.BUDGET_VERSION_ID = BV.BUDGET_VERSION_ID AND BL1.TXN_CURRENCY_CODE = BL.TXN_CURRENCY_CODE AND BL1.RESOURCE_ASSIGNMENT_ID = BL.RESOURCE_ASSIGNMENT_ID AND BL1.PFC_CUR_CONV_REJECTION_CODE IS NOT NULL ))
, 'N') PFC_CONV_REJECTION_FLAG
, NVL((SELECT 'Y'
FROM DUAL
WHERE EXISTS (SELECT NULL
FROM PA_BUDGET_LINES BL1
WHERE BL1.BUDGET_VERSION_ID = BV.BUDGET_VERSION_ID
AND BL1.TXN_CURRENCY_CODE = BL.TXN_CURRENCY_CODE
AND BL1.RESOURCE_ASSIGNMENT_ID = BL.RESOURCE_ASSIGNMENT_ID
AND BL1.START_DATE BETWEEN PA_FIN_PLAN_UTILS2.GET_BDGT_START_DATE
AND PA_FIN_PLAN_UTILS2.GET_BDGT_END_DATE
AND BL1.END_DATE BETWEEN PA_FIN_PLAN_UTILS2.GET_BDGT_START_DATE
AND PA_FIN_PLAN_UTILS2.GET_BDGT_END_DATE
AND BL1.PFC_CUR_CONV_REJECTION_CODE IS NOT NULL ))
, 'N') PERIOD_PFC_CONV_REJECTION_FLAG
, BL.OTHER_REJECTION_CODE
, (SELECT MESSAGE_TEXT
FROM FND_NEW_MESSAGES
WHERE MESSAGE_NAME = BL.OTHER_REJECTION_CODE
AND APPLICATION_ID = 275
AND LANGUAGE_CODE = USERENV('LANG') ) OTHER_REJECTION_MSG_DATA
, NVL((SELECT 'Y'
FROM DUAL WHERE EXISTS (SELECT NULL FROM PA_BUDGET_LINES BL1 WHERE BL1.BUDGET_VERSION_ID = BV.BUDGET_VERSION_ID AND BL1.TXN_CURRENCY_CODE = BL.TXN_CURRENCY_CODE AND BL1.RESOURCE_ASSIGNMENT_ID = BL.RESOURCE_ASSIGNMENT_ID AND BL1.OTHER_REJECTION_CODE IS NOT NULL ))
, 'N') OTHER_REJECTION_FLAG
, NVL((SELECT 'Y'
FROM DUAL
WHERE EXISTS (SELECT NULL
FROM PA_BUDGET_LINES BL1
WHERE BL1.BUDGET_VERSION_ID = BV.BUDGET_VERSION_ID
AND BL1.TXN_CURRENCY_CODE = BL.TXN_CURRENCY_CODE
AND BL1.RESOURCE_ASSIGNMENT_ID = BL.RESOURCE_ASSIGNMENT_ID
AND BL1.START_DATE BETWEEN PA_FIN_PLAN_UTILS2.GET_BDGT_START_DATE
AND PA_FIN_PLAN_UTILS2.GET_BDGT_END_DATE
AND BL1.END_DATE BETWEEN PA_FIN_PLAN_UTILS2.GET_BDGT_START_DATE
AND PA_FIN_PLAN_UTILS2.GET_BDGT_END_DATE
AND BL1.OTHER_REJECTION_CODE IS NOT NULL ))
, 'N') PERIOD_OTHER_REJECTION_FLAG
, RAM.RESOURCE_LIST_MEMBER_ID
, RLM.ALIAS
, RLM.RESOURCE_LIST_ID
FROM PA_BUDGET_VERSIONS BV
, PA_BUDGET_LINES BL
, PA_RESOURCE_ASSIGNMENTS RAM
, PA_RESOURCE_LIST_MEMBERS RLM
WHERE BV.BUDGET_VERSION_ID = BL.BUDGET_VERSION_ID
AND BL.RESOURCE_ASSIGNMENT_ID = RAM.RESOURCE_ASSIGNMENT_ID
AND RAM.RESOURCE_LIST_MEMBER_ID = RLM.RESOURCE_LIST_MEMBER_ID

Columns