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.GMS_RES_MAP dependencies on PA_RESOURCE_LIST_MEMBERS

Line 20: from pa_resource_list_members a,

16: Begin
17:
18: select a.resource_list_member_id
19: into p_resource_list_member_id
20: from pa_resource_list_members a,
21: pa_resources b,
22: pa_resource_types c
23: where c.resource_type_code = 'UNCLASSIFIED'
24: and b.resource_type_id = c.resource_type_id

Line 59: from pa_resource_list_members prlm,

55: Begin
56:
57: Select prlm.resource_list_member_id
58: into p_parent_rlmi
59: from pa_resource_list_members prlm,
60: pa_resources pr
61: where pr.resource_type_id = p_group_resource_type_id
62: and pr.name = p_name
63: and prlm.resource_id = pr.resource_id

Line 165: from pa_resource_list_members c

161: -- This cursor has been modified as part of Bug reference : 3631208
162:
163: Cursor get_resource_types is
164: select distinct c.resource_type_code resource_type_code
165: from pa_resource_list_members c
166: where c.resource_list_id = x_resource_list_id
167: and ((x_group_resource_type_id <> 0 and c.parent_member_id is not null)
168: or
169: (x_group_resource_type_id = 0 and c.parent_member_id is null)

Line 180: pa_resource_list_members c

176: -- Cursor modified as above
177: select distinct a.resource_type_code resource_type_code
178: from pa_resource_types a,
179: pa_resources b,
180: pa_resource_list_members c
181: where c.resource_list_id = x_resource_list_id
182: and b.resource_id = c.resource_id
183: and a.resource_type_id = b.resource_type_id
184: and ((x_group_resource_type_id <> 0 and c.parent_member_id is not null)

Line 203: pa_resource_list_members c

199: b.resource_type_id,
200: c.parent_member_id
201: from pa_resource_types a,
202: pa_resources b,
203: pa_resource_list_members c
204: where c.resource_list_id = x_resource_list_id
205: and b.resource_id = c.resource_id
206: and a.resource_type_id = b.resource_type_id
207: and c.enabled_flag='Y'

Line 220: pa_resource_list_members c

216: b.resource_type_id,
217: c.parent_member_id
218: from pa_resource_types a,
219: pa_resources b,
220: pa_resource_list_members c
221: where c.resource_list_id = x_resource_list_id
222: and b.resource_id = c.resource_id
223: and a.resource_type_id = b.resource_type_id
224: and c.enabled_flag='Y'

Line 255: from pa_resource_list_members

251: -- dbms_output.put_line('In Mapping UnCategorized');
252:
253: select resource_list_member_id
254: into x_resource_list_member_id
255: from pa_resource_list_members
256: where resource_list_id = x_resource_list_id
257: and NVL(migration_code,'M') ='M'; -- Bug 3626671
258:
259: x_prev_list_processed := x_resource_list_id;

Line 917: from pa_resource_list_members c

913: -- ## RLMI is RLMI for Unclassified resource
914:
915: select c.resource_list_member_id
916: into x_resource_list_member_id
917: from pa_resource_list_members c
918: where c.resource_list_id = x_resource_list_id
919: and c.enabled_flag = 'Y'
920: and c.alias = 'Unclassified'
921: and c.parent_member_id is NULL

Line 928: from pa_resource_list_members c

924: Else
925: -- ## Resource list grouped
926: select c.resource_list_member_id
927: into x_resource_list_member_id
928: from pa_resource_list_members c
929: where c.resource_list_id = x_resource_list_id
930: and c.enabled_flag = 'Y'
931: and c.alias = 'Unclassified'
932: and c.parent_member_id = l_parent_rlmi

Line 1181: from pa_resource_list_members c

1177: -- This cursor has been modified as part of Bug reference : 3631208
1178:
1179: Cursor get_resource_types is
1180: select distinct c.resource_type_code resource_type_code
1181: from pa_resource_list_members c
1182: where c.resource_list_id = x_resource_list_id
1183: and ((x_group_resource_type_id <> 0 and c.parent_member_id is not null)
1184: or
1185: (x_group_resource_type_id = 0 and c.parent_member_id is null)

Line 1196: pa_resource_list_members c

1192: -- Cursor modified as above ..
1193: select distinct a.resource_type_code resource_type_code
1194: from pa_resource_types a,
1195: pa_resources b,
1196: pa_resource_list_members c
1197: where c.resource_list_id = x_resource_list_id
1198: and b.resource_id = c.resource_id
1199: and a.resource_type_id = b.resource_type_id
1200: and ((x_group_resource_type_id <> 0 and c.parent_member_id is not null)

Line 1219: pa_resource_list_members c

1215: b.resource_type_id,
1216: c.parent_member_id
1217: from pa_resource_types a,
1218: pa_resources b,
1219: pa_resource_list_members c
1220: where c.resource_list_id = x_resource_list_id
1221: and b.resource_id = c.resource_id
1222: and a.resource_type_id = b.resource_type_id
1223: and c.enabled_flag='Y'

Line 1236: pa_resource_list_members c

1232: b.resource_type_id,
1233: c.parent_member_id
1234: from pa_resource_types a,
1235: pa_resources b,
1236: pa_resource_list_members c
1237: where c.resource_list_id = x_resource_list_id
1238: and b.resource_id = c.resource_id
1239: and a.resource_type_id = b.resource_type_id
1240: and c.enabled_flag='Y'

Line 1271: from pa_resource_list_members

1267: -- dbms_output.put_line('In Mapping UnCategorized');
1268:
1269: select resource_list_member_id
1270: into x_resource_list_member_id
1271: from pa_resource_list_members
1272: where resource_list_id = x_resource_list_id
1273: and NVL(migration_code,'M') ='M'; -- Bug 3626671
1274:
1275: x_prev_list_processed := x_resource_list_id;

Line 1808: from pa_resource_list_members c

1804: -- ## RLMI is RLMI for Unclassified resource
1805:
1806: select c.resource_list_member_id
1807: into x_resource_list_member_id
1808: from pa_resource_list_members c
1809: where c.resource_list_id = x_resource_list_id
1810: and c.enabled_flag = 'Y'
1811: and c.alias = 'Unclassified'
1812: and c.parent_member_id is NULL

Line 1819: from pa_resource_list_members c

1815: Else
1816: -- ## Resource list grouped
1817: select c.resource_list_member_id
1818: into x_resource_list_member_id
1819: from pa_resource_list_members c
1820: where c.resource_list_id = x_resource_list_id
1821: and c.enabled_flag = 'Y'
1822: and c.alias = 'Unclassified'
1823: and c.parent_member_id = l_parent_rlmi

Line 2614: pa_resource_list_members rlm,

2610: rta.resource_format_id,
2611: rt.resource_type_code
2612: FROM
2613: pa_resource_lists rl,
2614: pa_resource_list_members rlm,
2615: pa_resource_txn_attributes rta,
2616: pa_resources r,
2617: pa_resource_types rt,
2618: pa_resource_list_assignments rla

Line 2634: pa_resource_list_members rlmc

2630: AND NOT EXISTS
2631: ( SELECT
2632: 'Yes'
2633: FROM
2634: pa_resource_list_members rlmc
2635: WHERE
2636: rlmc.parent_member_id = rlm.resource_list_member_id
2637: AND NVL(rlmc.migration_code,'M') ='M' -- Bug 3626671
2638: --AND rlmc.enabled_flag = 'Y' Bug Fix 1370475

Line 2665: pa_resource_list_members rlmc,

2661: rtac.resource_format_id,
2662: rtc.resource_type_code
2663: FROM
2664: pa_resource_lists rl,
2665: pa_resource_list_members rlmc,
2666: pa_resource_list_members rlmp,
2667: pa_resource_txn_attributes rtac,
2668: pa_resource_txn_attributes rtap,
2669: pa_resources rc,

Line 2666: pa_resource_list_members rlmp,

2662: rtc.resource_type_code
2663: FROM
2664: pa_resource_lists rl,
2665: pa_resource_list_members rlmc,
2666: pa_resource_list_members rlmp,
2667: pa_resource_txn_attributes rtac,
2668: pa_resource_txn_attributes rtap,
2669: pa_resources rc,
2670: pa_resource_types rtc,