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.IEX_UWQ_PROM_ENUMS_PVT dependencies on AR_COLLECTORS

Line 171: ' FROM hz_customer_profiles hp,ar_collectors ac, ' ||

167: /* If (l_check >0 ) then
168:
169: l_str1 :=
170: ' OR ' || l_sel_enum_rec.work_q_view_for_primary_node || '.PARTY_ID' || ' IN (SELECT distinct hp.party_id ' ||
171: ' FROM hz_customer_profiles hp,ar_collectors ac, ' ||
172: ' iex_assignments iea ' ||
173: ' WHERE hp.collector_id = ac.collector_id ' ||
174: ' AND ac.resource_id = iea.resource_id ' ||
175: ' AND iea.alt_employee_id = :PERSON_ID ' ||

Line 182: ' FROM hz_customer_profiles hp,ar_collectors ac ' ||

178: l_security_where := l_str1 ;
179: Else
180: l_str1 :=
181: ' OR ' || l_sel_enum_rec.work_q_view_for_primary_node || '.PARTY_ID' || ' IN (SELECT distinct hp.party_id ' ||
182: ' FROM hz_customer_profiles hp,ar_collectors ac ' ||
183: ' WHERE hp.collector_id = ac.collector_id ' ||
184: ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
185: ' AND ac.employee_id = :PERSON_ID ';
186: l_str2 := ' UNION ALL SELECT hp.party_id ' ||

Line 187: ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||

183: ' WHERE hp.collector_id = ac.collector_id ' ||
184: ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
185: ' AND ac.employee_id = :PERSON_ID ';
186: l_str2 := ' UNION ALL SELECT hp.party_id ' ||
187: ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||
188: ' WHERE hp.collector_id = ac.collector_id ' ||
189: ' AND ac.resource_ID = jtgrp.group_id ' ||
190: ' AND ac.employee_id = :PERSON_ID ' ||
191: ' AND ac.resource_type = ''RS_GROUP'' ' ||

Line 417: SELECT collector_id from AR_COLLECTORS where resource_id = p_resource_id

413:
414: l_collector_id number;
415:
416: CURSOR c_collector_id IS
417: SELECT collector_id from AR_COLLECTORS where resource_id = p_resource_id
418: and resource_type = 'RS_RESOURCE';
419:
420: CURSOR c_person IS
421: select source_id

Line 735: SELECT collector_id from AR_COLLECTORS where resource_id = p_resource_id

731: l_collector_id number;
732: l_resource_id number;
733:
734: CURSOR c_collector_id IS
735: SELECT collector_id from AR_COLLECTORS where resource_id = p_resource_id
736: and resource_type = 'RS_RESOURCE';
737:
738: CURSOR c_person IS
739: select source_id

Line 1085: SELECT collector_id from AR_COLLECTORS where resource_id = p_resource_id

1081: l_collector_id number;
1082: l_resource_id number;
1083:
1084: CURSOR c_collector_id IS
1085: SELECT collector_id from AR_COLLECTORS where resource_id = p_resource_id
1086: and resource_type = 'RS_RESOURCE';
1087:
1088: CURSOR c_person IS
1089: select source_id

Line 1387: from ar_collectors where status='A' and

1383: AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
1384: AND NVL(DELETED_FLAG,'N') = 'N';
1385:
1386: select count(1) into l_group_check
1387: from ar_collectors where status='A' and
1388: nvl(inactive_date,sysdate)>=sysdate and resource_type='RS_GROUP';
1389:
1390:
1391: if l_check>0 or l_group_check>0 then

Line 1392: l_security_where := ' :person_id = :person_id and collector_resource_id in (select resource_id from ar_collectors where resource_type = ''RS_RESOURCE'' and resource_id = :COLLECTOR_RESOURCE_ID ';

1388: nvl(inactive_date,sysdate)>=sysdate and resource_type='RS_GROUP';
1389:
1390:
1391: if l_check>0 or l_group_check>0 then
1392: l_security_where := ' :person_id = :person_id and collector_resource_id in (select resource_id from ar_collectors where resource_type = ''RS_RESOURCE'' and resource_id = :COLLECTOR_RESOURCE_ID ';
1393: else
1394: l_security_where := ' :person_id = :person_id and collector_resource_id = :COLLECTOR_RESOURCE_ID ';
1395: end if;
1396:

Line 1399: ' union all SELECT ac.resource_id FROM iex_assignments iea,ar_collectors ac where '||

1395: end if;
1396:
1397: if l_check>0 then
1398: l_security_where := l_security_where ||
1399: ' union all SELECT ac.resource_id FROM iex_assignments iea,ar_collectors ac where '||
1400: ' iea.alt_employee_id = :PERSON_ID '||
1401: ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) '||
1402: ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) '||
1403: ' AND NVL(iea.DELETED_FLAG,''N'') = ''N'' '||

Line 1411: ' FROM ar_collectors ac , jtf_rs_group_members jtgrp '||

1407:
1408: if l_group_check>0 then
1409: l_security_where := l_security_where ||
1410: ' union all SELECT ac.resource_ID '||
1411: ' FROM ar_collectors ac , jtf_rs_group_members jtgrp '||
1412: ' WHERE ac.resource_ID = jtgrp.group_id '||
1413: ' AND ac.resource_type = ''RS_GROUP'''||
1414: ' AND NVL(jtgrp.delete_flag,''N'') = ''N'''||
1415: ' AND jtgrp.resource_ID = :COLLECTOR_RESOURCE_ID ';