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 IEX_ASSIGNMENTS

Line 110: SELECT count(*) into l_check from iex_assignments where

106: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
107:
108: l_node_counter := 0;
109: If (l_Access = 'T') then
110: SELECT count(*) into l_check from iex_assignments where
111: alt_resource_id = p_RESOURCE_ID
112: AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
113: AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
114: AND NVL(DELETED_FLAG,'N') = 'N';

Line 133: ' FROM iex_assignments iea ' ||

129: l_wclause(1) :=
130: ' (RESOURCE_ID = :RESOURCE_ID ' ||
131: ' OR :RESOURCE_ID ' ||
132: ' IN (select iea.alt_resource_id '||
133: ' FROM iex_assignments iea ' ||
134: ' WHERE nvl(iea.deleted_flag,''N'') = ''N'' ' ||
135: ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) ' ||
136: ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) ' ||
137: ' AND iea.alt_resource_id = :RESOURCE_ID ' ||

Line 146: ' FROM iex_assignments iea ' ||

142: l_wclause(2) :=
143: ' (RESOURCE_ID = :RESOURCE_ID ' ||
144: ' OR :RESOURCE_ID ' ||
145: ' IN (select iea.alt_resource_id '||
146: ' FROM iex_assignments iea ' ||
147: ' WHERE nvl(iea.deleted_flag,''N'') = ''N'' ' ||
148: ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) ' ||
149: ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) ' ||
150: ' AND iea.alt_resource_id = :RESOURCE_ID ' ||

Line 158: ' FROM iex_assignments iea ' ||

154: l_wclause(3) :=
155: ' (RESOURCE_ID = :RESOURCE_ID ' ||
156: ' OR :RESOURCE_ID ' ||
157: ' IN (select iea.alt_resource_id '||
158: ' FROM iex_assignments iea ' ||
159: ' WHERE nvl(iea.deleted_flag,''N'') = ''N'' ' ||
160: ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) ' ||
161: ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) ' ||
162: ' AND iea.alt_resource_id = :RESOURCE_ID ' ||

Line 172: ' iex_assignments iea ' ||

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 ' ||
176: ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) ' ||

Line 210: ' FROM iex_assignments iea ' ||

206: --Bug4775893. Fix by LKKUMAR on 14-Dec-2005. Start.
207: l_default_where := ' ( RESOURCE_ID = :RESOURCE_ID and :UWQ_STATUS = :UWQ_STATUS ' ||
208: ' OR :RESOURCE_ID ' ||
209: ' IN (select iea.alt_resource_id '||
210: ' FROM iex_assignments iea ' ||
211: ' WHERE nvl(iea.deleted_flag,''N'') = ''N'' ' ||
212: ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) ' ||
213: ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) ' ||
214: ' AND iea.alt_resource_id = :RESOURCE_ID ' ||

Line 445: SELECT count(*) INTO l_check FROM iex_assignments where

441: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
442: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
443:
444: /* IF (l_Access = 'T') THEN
445: SELECT count(*) INTO l_check FROM iex_assignments where
446: alt_resource_id = p_RESOURCE_ID
447: AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
448: AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
449: AND NVL(DELETED_FLAG,'N') = 'N';

Line 788: SELECT count(*) INTO l_check FROM iex_assignments where

784: l_str_bkr := ' AND NUMBER_OF_BANKRUPTCIES = 0 ';
785:
786:
787: IF (l_Access = 'T') then
788: SELECT count(*) INTO l_check FROM iex_assignments where
789: alt_resource_id = P_RESOURCE_ID
790: AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
791: AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
792: AND NVL(DELETED_FLAG,'N') = 'N';

Line 1128: SELECT count(*) INTO l_check FROM iex_assignments where

1124: l_str_bkr := ' AND NUMBER_OF_BANKRUPTCIES = 0 ';
1125:
1126:
1127: IF l_Access = 'T' then
1128: SELECT count(*) INTO l_check FROM iex_assignments where
1129: alt_resource_id = p_RESOURCE_ID
1130: AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
1131: AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
1132: AND NVL(DELETED_FLAG,'N') = 'N';

Line 1380: SELECT count(*) INTO l_check FROM iex_assignments where

1376:
1377: BEGIN
1378:
1379: IF (l_Access = 'T') THEN
1380: SELECT count(*) INTO l_check FROM iex_assignments where
1381: alt_resource_id = p_RESOURCE_ID
1382: AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
1383: AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
1384: AND NVL(DELETED_FLAG,'N') = 'N';

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'' '||