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_RESOURCE_MAPPING dependencies on PA_RESOURCE_CLASSES_B

Line 878: pa_resource_classes_b cls

874: cls.RESOURCE_CLASS_ID,
875: cls.RESOURCE_CLASS_CODE
876: FROM
877: pa_res_list_map_tmp3 tmp3,
878: pa_resource_classes_b cls
879: WHERE
880: RESOURCE_LIST_MEMBER_ID IS NULL AND
881: nvl(tmp3.resource_class_id, l_resource_class_id) = cls.resource_class_id;
882:

Line 1187: FROM pa_Res_formats_b b,PA_RESOURCE_CLASSES_B c, PA_ACT_PRL_PRECEDENCE d

1183:
1184: UPDATE pa_res_list_map_tmp3 a
1185: SET ( a.RESOURCE_CLASS_ID,a.RESOURCE_CLASS_CODE)
1186: = (SELECT c.resource_class_id ,c.resource_class_code
1187: FROM pa_Res_formats_b b,PA_RESOURCE_CLASSES_B c, PA_ACT_PRL_PRECEDENCE d
1188: WHERE b.resource_class_id = c.resource_class_id
1189: AND a.res_format_id = b.res_format_id
1190: AND b.res_format_id = d.res_format_id
1191: AND d.res_prec_id = g_res_prec_id

Line 1196: FROM pa_Res_formats_b b1,PA_RESOURCE_CLASSES_B c1, PA_ACT_PRL_PRECEDENCE d1

1192: and d.eff_res_format_id = p_format_id
1193: )
1194: WHERE EXISTS (
1195: SELECT 'x'
1196: FROM pa_Res_formats_b b1,PA_RESOURCE_CLASSES_B c1, PA_ACT_PRL_PRECEDENCE d1
1197: WHERE b1.resource_class_id = c1.resource_class_id
1198: AND b1.res_format_id = d1.res_format_id
1199: AND a.res_format_id = b1.res_format_id
1200: AND d1.res_prec_id = g_res_prec_id

Line 1268: pa_resource_classes_b

1264: IS
1265: SELECT
1266: resource_class_id
1267: FROM
1268: pa_resource_classes_b
1269: WHERE g_resource_class_flag = 'Y'
1270: UNION
1271: SELECT 1
1272: FROM dual

Line 1384: PA_RESOURCE_CLASSES_B classes,

1380: FROM PA_EXPENDITURE_TYPES typ
1381: WHERE typ.EXPENDITURE_TYPE = tmp1.EXPENDITURE_TYPE ) )
1382: ,tmp1.ITEM_CATEGORY_ID = nvl(tmp1.ITEM_CATEGORY_ID, (SELECT cat.CATEGORY_ID
1383: FROM
1384: PA_RESOURCE_CLASSES_B classes,
1385: PA_PLAN_RES_DEFAULTS cls,
1386: MTL_ITEM_CATEGORIES cat
1387: WHERE
1388: classes.RESOURCE_CLASS_CODE = 'MATERIAL_ITEMS' and

Line 1403: PA_RESOURCE_CLASSES_B classes,

1399: WHERE tmp1.EXPENDITURE_CATEGORY IS NULL;
1400: UPDATE pa_res_list_map_tmp1 tmp1
1401: SET tmp1.ITEM_CATEGORY_ID = (SELECT cat.CATEGORY_ID
1402: FROM
1403: PA_RESOURCE_CLASSES_B classes,
1404: PA_PLAN_RES_DEFAULTS cls,
1405: MTL_ITEM_CATEGORIES cat
1406: WHERE
1407: classes.RESOURCE_CLASS_CODE = 'MATERIAL_ITEMS' and