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.

[Home] [Help]

APPS.IEX_UWQ_PROM_ENUMS_PVT dependencies on IEX_ASSIGNMENTS

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

112: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
113:
114: l_node_counter := 0;
115: If (l_Access = 'T') then
116: SELECT count(*) into l_check from iex_assignments where
117: alt_resource_id = p_RESOURCE_ID
118: AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
119: AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
120: AND NVL(DELETED_FLAG,'N') = 'N';

Line 144: ' FROM iex_assignments iea ' ||

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

Line 157: ' FROM iex_assignments iea ' ||

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

Line 169: ' FROM iex_assignments iea ' ||

165: l_wclause(3) :=
166: ' (RESOURCE_ID = :RESOURCE_ID ' ||
167: ' OR :RESOURCE_ID ' ||
168: ' IN (select iea.alt_resource_id '||
169: ' FROM iex_assignments iea ' ||
170: ' WHERE nvl(iea.deleted_flag,''N'') = ''N'' ' ||
171: ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) ' ||
172: ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) ' ||
173: ' AND iea.alt_resource_id = :RESOURCE_ID ' ||

Line 183: ' iex_assignments iea ' ||

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

Line 225: ' FROM iex_assignments iea ' ||

221: --Bug4775893. Fix by LKKUMAR on 14-Dec-2005. Start.
222: l_default_where := ' ( RESOURCE_ID = :RESOURCE_ID and :UWQ_STATUS = :UWQ_STATUS ' ||
223: ' OR :RESOURCE_ID ' ||
224: ' IN (select iea.alt_resource_id '||
225: ' FROM iex_assignments iea ' ||
226: ' WHERE nvl(iea.deleted_flag,''N'') = ''N'' ' ||
227: ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) ' ||
228: ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) ' ||
229: ' AND iea.alt_resource_id = :RESOURCE_ID ' ||

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

473: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
474: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
475:
476: /* IF (l_Access = 'T') THEN
477: SELECT count(*) INTO l_check FROM iex_assignments where
478: alt_resource_id = p_RESOURCE_ID
479: AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
480: AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
481: AND NVL(DELETED_FLAG,'N') = 'N';

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

861: l_str_bkr := ' AND NUMBER_OF_BANKRUPTCIES = 0 ';
862:
863:
864: IF (l_Access = 'T') then
865: SELECT count(*) INTO l_check FROM iex_assignments where
866: alt_resource_id = P_RESOURCE_ID
867: AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
868: AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
869: AND NVL(DELETED_FLAG,'N') = 'N';

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

1246: l_str_bkr := ' AND NUMBER_OF_BANKRUPTCIES = 0 ';
1247:
1248:
1249: IF l_Access = 'T' then
1250: SELECT count(*) INTO l_check FROM iex_assignments where
1251: alt_resource_id = p_RESOURCE_ID
1252: AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
1253: AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
1254: AND NVL(DELETED_FLAG,'N') = 'N';

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

1533:
1534: BEGIN
1535:
1536: IF (l_Access = 'T') THEN
1537: SELECT count(*) INTO l_check FROM iex_assignments where
1538: alt_resource_id = p_RESOURCE_ID
1539: AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
1540: AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
1541: AND NVL(DELETED_FLAG,'N') = 'N';

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