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 182: ' FROM hz_customer_profiles hp,ar_collectors ac, ' ||

178: /* If (l_check >0 ) then
179:
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: ' iex_assignments iea ' ||
184: ' WHERE hp.collector_id = ac.collector_id ' ||
185: ' AND ac.resource_id = iea.resource_id ' ||
186: ' AND iea.alt_employee_id = :PERSON_ID ' ||

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

189: l_security_where := l_str1 ;
190: Else
191: l_str1 :=
192: ' OR ' || l_sel_enum_rec.work_q_view_for_primary_node || '.PARTY_ID' || ' IN (SELECT distinct hp.party_id ' ||
193: ' FROM hz_customer_profiles hp,ar_collectors ac ' ||
194: ' WHERE hp.collector_id = ac.collector_id ' ||
195: ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
196: ' AND ac.employee_id = :PERSON_ID ';
197: l_str2 := ' UNION ALL SELECT hp.party_id ' ||

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

194: ' WHERE hp.collector_id = ac.collector_id ' ||
195: ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
196: ' AND ac.employee_id = :PERSON_ID ';
197: l_str2 := ' UNION ALL SELECT hp.party_id ' ||
198: ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||
199: ' WHERE hp.collector_id = ac.collector_id ' ||
200: ' AND ac.resource_ID = jtgrp.group_id ' ||
201: ' AND ac.employee_id = :PERSON_ID ' ||
202: ' AND ac.resource_type = ''RS_GROUP'' ' ||

Line 437: SELECT collector_id from AR_COLLECTORS where resource_id = p_resource_id

433:
434: l_collector_id number;
435:
436: CURSOR c_collector_id IS
437: SELECT collector_id from AR_COLLECTORS where resource_id = p_resource_id
438: and resource_type = 'RS_RESOURCE';
439:
440: CURSOR c_person IS
441: select source_id

Line 800: SELECT collector_id from AR_COLLECTORS where resource_id = p_resource_id

796: l_collector_id number;
797: l_resource_id number;
798:
799: CURSOR c_collector_id IS
800: SELECT collector_id from AR_COLLECTORS where resource_id = p_resource_id
801: and resource_type = 'RS_RESOURCE';
802:
803: CURSOR c_person IS
804: select source_id

Line 1195: SELECT collector_id from AR_COLLECTORS where resource_id = p_resource_id

1191: l_collector_id number;
1192: l_resource_id number;
1193:
1194: CURSOR c_collector_id IS
1195: SELECT collector_id from AR_COLLECTORS where resource_id = p_resource_id
1196: and resource_type = 'RS_RESOURCE';
1197:
1198: CURSOR c_person IS
1199: select source_id

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

1540: AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
1541: AND NVL(DELETED_FLAG,'N') = 'N';
1542:
1543: select count(1) into l_group_check
1544: from ar_collectors where status='A' and
1545: nvl(inactive_date,sysdate)>=sysdate and resource_type='RS_GROUP';
1546:
1547:
1548: if l_check>0 or l_group_check>0 then

Line 1549: 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 ';

1545: nvl(inactive_date,sysdate)>=sysdate and resource_type='RS_GROUP';
1546:
1547:
1548: if l_check>0 or l_group_check>0 then
1549: 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 ';
1550: else
1551: l_security_where := ' :person_id = :person_id and collector_resource_id = :COLLECTOR_RESOURCE_ID ';
1552: end if;
1553:

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

1552: end if;
1553:
1554: if l_check>0 then
1555: l_security_where := l_security_where ||
1556: ' union all SELECT ac.resource_id FROM iex_assignments iea,ar_collectors ac where '||
1557: ' iea.alt_employee_id = :PERSON_ID '||
1558: ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) '||
1559: ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) '||
1560: ' AND NVL(iea.DELETED_FLAG,''N'') = ''N'' '||

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

1564:
1565: if l_group_check>0 then
1566: l_security_where := l_security_where ||
1567: ' union all SELECT ac.resource_ID '||
1568: ' FROM ar_collectors ac , jtf_rs_group_members jtgrp '||
1569: ' WHERE ac.resource_ID = jtgrp.group_id '||
1570: ' AND ac.resource_type = ''RS_GROUP'''||
1571: ' AND NVL(jtgrp.delete_flag,''N'') = ''N'''||
1572: ' AND jtgrp.resource_ID = :COLLECTOR_RESOURCE_ID ';