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.

APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_PLAN_RL_FORMATS

Line 7006: * from the pa_plan_rl_formats table which do not

7002: * and Requirements.
7003: * The calling API would pass a resource_list_id
7004: * This API would then get all the formats
7005: * associated with the resource_list passed
7006: * from the pa_plan_rl_formats table which do not
7007: * have res_type_code
7008: * of Named_person,Bom_Labor,Resource_Class(for Req)
7009: * of Bom_Labor,Resource_Class(for asgmt)
7010: * - It then gets the format which has the highest

Line 7029: from pa_res_formats_b a,pa_res_types_b b, pa_plan_rl_formats c

7025: *****************************************/
7026: Cursor c_get_asgmt_res_formats
7027: IS
7028: select a.res_format_id
7029: from pa_res_formats_b a,pa_res_types_b b, pa_plan_rl_formats c
7030: where a.resource_class_id = 1
7031: and a.res_type_id = b.res_type_id (+)
7032: and c.res_format_id = a.res_format_id
7033: and c.resource_list_id = p_resource_list_id

Line 7045: from pa_res_formats_b a,pa_res_types_b b, pa_plan_rl_formats c

7041: *****************************************/
7042: Cursor c_get_req_res_formats
7043: IS
7044: select a.res_format_id
7045: from pa_res_formats_b a,pa_res_types_b b, pa_plan_rl_formats c
7046: where a.resource_class_id = 1
7047: and a.res_type_id = b.res_type_id (+)
7048: and c.res_format_id = a.res_format_id
7049: and c.resource_list_id = p_resource_list_id