eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PA_FP_BUDGET_LINE_REJECTIONS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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