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 7164: * from the pa_plan_rl_formats table which do not

7160: * and Requirements.
7161: * The calling API would pass a resource_list_id
7162: * This API would then get all the formats
7163: * associated with the resource_list passed
7164: * from the pa_plan_rl_formats table which do not
7165: * have res_type_code
7166: * of Named_person,Bom_Labor,Resource_Class(for Req)
7167: * of Bom_Labor,Resource_Class(for asgmt)
7168: * - It then gets the format which has the highest

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

7183: *****************************************/
7184: Cursor c_get_asgmt_res_formats
7185: IS
7186: select a.res_format_id
7187: from pa_res_formats_b a,pa_res_types_b b, pa_plan_rl_formats c
7188: where a.resource_class_id = 1
7189: and a.res_type_id = b.res_type_id (+)
7190: and c.res_format_id = a.res_format_id
7191: and c.resource_list_id = p_resource_list_id

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

7199: *****************************************/
7200: Cursor c_get_req_res_formats
7201: IS
7202: select a.res_format_id
7203: from pa_res_formats_b a,pa_res_types_b b, pa_plan_rl_formats c
7204: where a.resource_class_id = 1
7205: and a.res_type_id = b.res_type_id (+)
7206: and c.res_format_id = a.res_format_id
7207: and c.resource_list_id = p_resource_list_id