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_DELIN_ENUMS_PVT dependencies on IEX_ASSIGNMENTS

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

192: l_default_where := ' RESOURCE_ID = :RESOURCE_ID AND :UWQ_STATUS = :UWQ_STATUS ';
193:
194: -- Territory Assignment Changes
195: IF (l_Access = 'T') THEN
196: SELECT count(*) into l_check from iex_assignments where
197: alt_resource_id = p_RESOURCE_ID
198: AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
199: AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
200: AND NVL(DELETED_FLAG,'N') = 'N';

Line 208: ' iex_assignments iea ' ||

204: l_security_where :=
205: --'customer_id in (select hp.party_id '||
206: l_filter_col_str1|| -- Added for Bug #6311505 bibeura 23-Oct-2007
207: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
208: ' iex_assignments iea ' ||
209: ' WHERE hp.collector_id = ac.collector_id ' ||
210: l_filter_cond_str|| -- Added for Bug #6311505 bibeura 23-Oct-2007
211: -- ' AND hp.cust_account_id = -1 ' || Bug4775052. Fix By LKKUMAR on 29-Nov-2005
212: ' AND ac.resource_id = iea.resource_id ' ||

Line 343: ' iex_assignments iea ' ||

339: l_security_where :=
340: --'customer_id in (select hp.party_id '||
341: l_filter_col_str1|| -- Added for Bug #6311505 bibeura 23-Oct-2007
342: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
343: ' iex_assignments iea ' ||
344: ' WHERE hp.collector_id = ac.collector_id ' ||
345: l_filter_cond_str|| -- Added for Bug #6311505 bibeura 23-Oct-2007
346: -- ' AND hp.cust_account_id = -1 ' || Bug4775052. Fix By LKKUMAR on 29-Nov-2005
347: ' AND ac.resource_id = iea.resource_id ' ||

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

599: OPEN c_collector_id;
600: FETCH c_collector_ID INTO l_collector_id;
601: CLOSE c_collector_id;
602:
603: SELECT count(*) INTO l_check FROM iex_assignments where
604: alt_resource_id = p_RESOURCE_ID
605: AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
606: AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
607: AND NVL(DELETED_FLAG,'N') = 'N';

Line 620: ' iex_assignments iea ' ||

616: /* If (l_check > 0 ) then
617: l_security_where :=
618: 'party_id in (select hp.party_id ' ||
619: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
620: ' iex_assignments iea ' ||
621: ' WHERE hp.collector_id = ac.collector_id ' ||
622: ' AND ac.resource_id = iea.resource_id ' ||
623: ' AND hp.cust_account_id = -1 ' ||
624: ' AND iea.alt_employee_id = :PERSON_ID ' ||

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

672: l_security_where := ' :person_id = :person_id and collector_resource_id = :COLLECTOR_RESOURCE_ID ';
673: end if;
674:
675: if l_check>0 then
676: l_security_where := l_security_where || ' union all SELECT ac.resource_id FROM iex_assignments iea,ar_collectors ac where '||
677: ' iea.alt_employee_id = :PERSON_ID '||
678: ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) '||
679: ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) '||
680: ' AND NVL(iea.DELETED_FLAG,''N'') = ''N'' '||

Line 810: ' iex_assignments iea ' ||

806: /* If (l_check > 0 ) then
807: l_security_where :=
808: 'party_id in (select hp.party_id '||
809: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
810: ' iex_assignments iea ' ||
811: ' WHERE hp.collector_id = ac.collector_id ' ||
812: ' AND ac.resource_id = iea.resource_id ' ||
813: ' AND hp.cust_account_id = -1 ' ||
814: ' AND iea.alt_employee_id = :PERSON_ID ' ||

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

862: l_security_where := ' :person_id = :person_id and collector_resource_id = :COLLECTOR_RESOURCE_ID ';
863: end if;
864:
865: if l_check>0 then
866: l_security_where := l_security_where || ' union all SELECT ac.resource_id FROM iex_assignments iea,ar_collectors ac where '||
867: ' iea.alt_employee_id = :PERSON_ID '||
868: ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) '||
869: ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) '||
870: ' AND NVL(iea.DELETED_FLAG,''N'') = ''N'' '||

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

1126: OPEN c_collector_id;
1127: FETCH c_collector_id INTO l_collector_id;
1128: CLOSE c_collector_id;
1129:
1130: SELECT count(*) INTO l_check FROM iex_assignments where
1131: alt_resource_id = P_RESOURCE_ID
1132: AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
1133: AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
1134: --Bug4646657 . Check for Deleted flag .Fixed by lkkumar. Start.

Line 1149: ' iex_assignments iea ' ||

1145: If (l_check > 0) then
1146: l_security_where :=
1147: 'party_id in (select hp.party_id '||
1148: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
1149: ' iex_assignments iea ' ||
1150: ' WHERE hp.collector_id = ac.collector_id ' ||
1151: ' AND hp.cust_account_id = -1 ' ||
1152: ' AND ac.resource_id = iea.resource_id ' ||
1153: ' AND iea.alt_employee_id = :PERSON_ID '||

Line 1200: ' iex_assignments iea ' ||

1196: If (l_check > 0) then
1197: l_security_where :=
1198: 'party_id in (select hp.party_id '||
1199: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
1200: ' iex_assignments iea ' ||
1201: ' WHERE hp.collector_id = ac.collector_id ' ||
1202: ' AND ' || l_view_name ||
1203: '.cust_account_id = hp.cust_account_id ' ||
1204: ' AND ac.resource_id = iea.resource_id ' ||

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

1264: l_security_where := ' :person_id = :person_id and collector_resource_id = :COLLECTOR_RESOURCE_ID ';
1265: end if;
1266:
1267: if l_check>0 then
1268: l_security_where := l_security_where || ' union all SELECT ac.resource_id FROM iex_assignments iea,ar_collectors ac where '||
1269: ' iea.alt_employee_id = :PERSON_ID '||
1270: ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) '||
1271: ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) '||
1272: ' AND NVL(iea.DELETED_FLAG,''N'') = ''N'' '||

Line 1386: ' iex_assignments iea ' ||

1382: If (l_check > 0) then
1383: l_security_where :=
1384: 'party_id in (select hp.party_id '||
1385: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
1386: ' iex_assignments iea ' ||
1387: ' WHERE hp.collector_id = ac.collector_id ' ||
1388: ' AND hp.cust_account_id = -1 ' ||
1389: ' AND ac.resource_id = iea.resource_id ' ||
1390: ' AND iea.alt_employee_id = :PERSON_ID ' ||

Line 1438: ' iex_assignments iea ' ||

1434: If (l_check > 0) then
1435: l_security_where :=
1436: 'party_id in (select hp.party_id '||
1437: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
1438: ' iex_assignments iea ' ||
1439: ' WHERE hp.collector_id = ac.collector_id ' ||
1440: ' AND ' || l_view_name ||
1441: '.cust_account_id = hp.cust_account_id ' ||
1442: ' AND ac.resource_id = iea.resource_id ' ||

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

1502: l_security_where := ' :person_id = :person_id and collector_resource_id = :COLLECTOR_RESOURCE_ID ';
1503: end if;
1504:
1505: if l_check>0 then
1506: l_security_where := l_security_where || ' union all SELECT ac.resource_id FROM iex_assignments iea,ar_collectors ac where '||
1507: ' iea.alt_employee_id = :PERSON_ID '||
1508: ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) '||
1509: ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) '||
1510: ' AND NVL(iea.DELETED_FLAG,''N'') = ''N'' '||

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

1773: OPEN c_collector_id;
1774: FETCH c_collector_id INTO l_collector_id;
1775: CLOSE c_collector_id;
1776:
1777: SELECT count(*) INTO l_check FROM iex_assignments where
1778: alt_resource_id = p_RESOURCE_ID
1779: AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
1780: AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
1781: --Bug4646657 . Check for Deleted flag .Fixed by lkkumar. Start.

Line 1797: ' iex_assignments iea ' ||

1793: If (l_check > 0) then
1794: l_security_where :=
1795: 'party_id in (select hp.party_id '||
1796: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
1797: ' iex_assignments iea ' ||
1798: ' WHERE hp.collector_id = ac.collector_id ' ||
1799: ' AND hp.cust_account_id = -1 ' ||
1800: ' AND ac.resource_id = iea.resource_id ' ||
1801: ' AND iea.alt_employee_id = :PERSON_ID ' ||

Line 1847: ' iex_assignments iea ' ||

1843: If (l_check > 0) then
1844: l_security_where :=
1845: 'party_id in (select hp.party_id '||
1846: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
1847: ' iex_assignments iea ' ||
1848: ' WHERE hp.collector_id = ac.collector_id ' ||
1849: ' AND ' || l_view_name ||
1850: '.cust_account_id = hp.cust_account_id ' ||
1851: ' AND ac.resource_id = iea.resource_id ' ||

Line 1907: ' iex_assignments iea ' ||

1903: If (l_check > 0) then
1904: l_security_where :=
1905: 'party_id in (select hp.party_id '||
1906: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
1907: ' iex_assignments iea ' ||
1908: ' WHERE hp.collector_id = ac.collector_id ' ||
1909: ' AND ' || l_view_name ||
1910: '.site_use_id = hp.site_use_id ' ||
1911: ' AND ac.resource_id = iea.resource_id ' ||

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

1963: l_security_where := ' :person_id = :person_id and collector_resource_id = :COLLECTOR_RESOURCE_ID ';
1964: end if;
1965:
1966: if l_check>0 then
1967: l_security_where := l_security_where || ' union all SELECT ac.resource_id FROM iex_assignments iea,ar_collectors ac where '||
1968: ' iea.alt_employee_id = :PERSON_ID '||
1969: ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) '||
1970: ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) '||
1971: ' AND NVL(iea.DELETED_FLAG,''N'') = ''N'' '||

Line 2090: ' iex_assignments iea ' ||

2086: If (l_check > 0) then
2087: l_security_where :=
2088: 'party_id in (select hp.party_id '||
2089: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
2090: ' iex_assignments iea ' ||
2091: ' WHERE hp.collector_id = ac.collector_id ' ||
2092: ' AND hp.cust_account_id = -1 ' ||
2093: ' AND ac.resource_id = iea.resource_id ' ||
2094: ' AND iea.alt_employee_id = :PERSON_ID ' ||

Line 2140: ' iex_assignments iea ' ||

2136: If (l_check > 0) then
2137: l_security_where :=
2138: 'party_id in (select hp.party_id '||
2139: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
2140: ' iex_assignments iea ' ||
2141: ' WHERE hp.collector_id = ac.collector_id ' ||
2142: ' AND ' || l_view_name ||
2143: '.cust_account_id = hp.cust_account_id ' ||
2144: ' AND ac.resource_id = iea.resource_id ' ||

Line 2196: ' iex_assignments iea ' ||

2192: If (l_check > 0) then
2193: l_security_where :=
2194: 'party_id in (select hp.party_id '||
2195: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
2196: ' iex_assignments iea ' ||
2197: ' WHERE hp.collector_id = ac.collector_id ' ||
2198: ' AND ' || l_view_name ||
2199: '.site_use_id = hp.site_use_id ' ||
2200: ' AND ac.resource_id = iea.resource_id ' ||

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

2255: l_security_where := ' :person_id = :person_id and collector_resource_id = :COLLECTOR_RESOURCE_ID ';
2256: end if;
2257:
2258: if l_check>0 then
2259: l_security_where := l_security_where || ' union all SELECT ac.resource_id FROM iex_assignments iea,ar_collectors ac where '||
2260: ' iea.alt_employee_id = :PERSON_ID '||
2261: ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) '||
2262: ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) '||
2263: ' AND NVL(iea.DELETED_FLAG,''N'') = ''N'' '||