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.IEC_SUBSET_PVT dependencies on IEC_O_TRANSITION_PHONES

Line 1259: ' SET A.REASON_CODE_S1 = ( SELECT /+ index(B iec_o_transition_phones_u1) / ITM_CC_TZ_ID ' ||

1255: -- architecture away from ALE then this will no longer be needed.
1256: ----------------------------------------------------------------
1257: TRACELOG('UPDATING VIEW ');
1258: EXECUTE IMMEDIATE 'UPDATE ' || P_STYPE_VIEW_NAME || ' A ' ||
1259: ' SET A.REASON_CODE_S1 = ( SELECT /*+ index(B iec_o_transition_phones_u1) */ ITM_CC_TZ_ID ' ||
1260: ' FROM IEC_O_TRANSITION_PHONES B' ||
1261: ' WHERE B.PHONE_INDEX = 1 ' ||
1262: ' AND B.LIST_ENTRY_ID = A.LIST_ENTRY_ID ' ||
1263: ' AND B.LIST_ID = A.LIST_HEADER_ID ) ' ||

Line 1260: ' FROM IEC_O_TRANSITION_PHONES B' ||

1256: ----------------------------------------------------------------
1257: TRACELOG('UPDATING VIEW ');
1258: EXECUTE IMMEDIATE 'UPDATE ' || P_STYPE_VIEW_NAME || ' A ' ||
1259: ' SET A.REASON_CODE_S1 = ( SELECT /*+ index(B iec_o_transition_phones_u1) */ ITM_CC_TZ_ID ' ||
1260: ' FROM IEC_O_TRANSITION_PHONES B' ||
1261: ' WHERE B.PHONE_INDEX = 1 ' ||
1262: ' AND B.LIST_ENTRY_ID = A.LIST_ENTRY_ID ' ||
1263: ' AND B.LIST_ID = A.LIST_HEADER_ID ) ' ||
1264: ' , A.REASON_CODE_S2 = ( SELECT /*+ index(C iec_o_transition_phones_u1) */ C.ITM_CC_TZ_ID ' ||

Line 1264: ' , A.REASON_CODE_S2 = ( SELECT /+ index(C iec_o_transition_phones_u1) / C.ITM_CC_TZ_ID ' ||

1260: ' FROM IEC_O_TRANSITION_PHONES B' ||
1261: ' WHERE B.PHONE_INDEX = 1 ' ||
1262: ' AND B.LIST_ENTRY_ID = A.LIST_ENTRY_ID ' ||
1263: ' AND B.LIST_ID = A.LIST_HEADER_ID ) ' ||
1264: ' , A.REASON_CODE_S2 = ( SELECT /*+ index(C iec_o_transition_phones_u1) */ C.ITM_CC_TZ_ID ' ||
1265: ' FROM IEC_O_TRANSITION_PHONES C' ||
1266: ' WHERE C.PHONE_INDEX = 2 ' ||
1267: ' AND C.LIST_ENTRY_ID = A.LIST_ENTRY_ID ' ||
1268: ' AND C.LIST_ID = A.LIST_HEADER_ID ) ' ||

Line 1265: ' FROM IEC_O_TRANSITION_PHONES C' ||

1261: ' WHERE B.PHONE_INDEX = 1 ' ||
1262: ' AND B.LIST_ENTRY_ID = A.LIST_ENTRY_ID ' ||
1263: ' AND B.LIST_ID = A.LIST_HEADER_ID ) ' ||
1264: ' , A.REASON_CODE_S2 = ( SELECT /*+ index(C iec_o_transition_phones_u1) */ C.ITM_CC_TZ_ID ' ||
1265: ' FROM IEC_O_TRANSITION_PHONES C' ||
1266: ' WHERE C.PHONE_INDEX = 2 ' ||
1267: ' AND C.LIST_ENTRY_ID = A.LIST_ENTRY_ID ' ||
1268: ' AND C.LIST_ID = A.LIST_HEADER_ID ) ' ||
1269: ' , A.REASON_CODE_S3 = ( SELECT /*+ index(D iec_o_transition_phones_u1) */ D.ITM_CC_TZ_ID ' ||

Line 1269: ' , A.REASON_CODE_S3 = ( SELECT /+ index(D iec_o_transition_phones_u1) / D.ITM_CC_TZ_ID ' ||

1265: ' FROM IEC_O_TRANSITION_PHONES C' ||
1266: ' WHERE C.PHONE_INDEX = 2 ' ||
1267: ' AND C.LIST_ENTRY_ID = A.LIST_ENTRY_ID ' ||
1268: ' AND C.LIST_ID = A.LIST_HEADER_ID ) ' ||
1269: ' , A.REASON_CODE_S3 = ( SELECT /*+ index(D iec_o_transition_phones_u1) */ D.ITM_CC_TZ_ID ' ||
1270: ' FROM IEC_O_TRANSITION_PHONES D' ||
1271: ' WHERE D.PHONE_INDEX = 3 ' ||
1272: ' AND D.LIST_ENTRY_ID = A.LIST_ENTRY_ID ' ||
1273: ' AND D.LIST_ID = A.LIST_HEADER_ID ) ' ||

Line 1270: ' FROM IEC_O_TRANSITION_PHONES D' ||

1266: ' WHERE C.PHONE_INDEX = 2 ' ||
1267: ' AND C.LIST_ENTRY_ID = A.LIST_ENTRY_ID ' ||
1268: ' AND C.LIST_ID = A.LIST_HEADER_ID ) ' ||
1269: ' , A.REASON_CODE_S3 = ( SELECT /*+ index(D iec_o_transition_phones_u1) */ D.ITM_CC_TZ_ID ' ||
1270: ' FROM IEC_O_TRANSITION_PHONES D' ||
1271: ' WHERE D.PHONE_INDEX = 3 ' ||
1272: ' AND D.LIST_ENTRY_ID = A.LIST_ENTRY_ID ' ||
1273: ' AND D.LIST_ID = A.LIST_HEADER_ID ) ' ||
1274: ' , A.REASON_CODE_S4 = ( SELECT /*+ index(E iec_o_transition_phones_u1) */ E.ITM_CC_TZ_ID ' ||

Line 1274: ' , A.REASON_CODE_S4 = ( SELECT /+ index(E iec_o_transition_phones_u1) / E.ITM_CC_TZ_ID ' ||

1270: ' FROM IEC_O_TRANSITION_PHONES D' ||
1271: ' WHERE D.PHONE_INDEX = 3 ' ||
1272: ' AND D.LIST_ENTRY_ID = A.LIST_ENTRY_ID ' ||
1273: ' AND D.LIST_ID = A.LIST_HEADER_ID ) ' ||
1274: ' , A.REASON_CODE_S4 = ( SELECT /*+ index(E iec_o_transition_phones_u1) */ E.ITM_CC_TZ_ID ' ||
1275: ' FROM IEC_O_TRANSITION_PHONES E' ||
1276: ' WHERE E.PHONE_INDEX = 4 ' ||
1277: ' AND E.LIST_ENTRY_ID = A.LIST_ENTRY_ID ' ||
1278: ' AND E.LIST_ID = A.LIST_HEADER_ID ) ' ||

Line 1275: ' FROM IEC_O_TRANSITION_PHONES E' ||

1271: ' WHERE D.PHONE_INDEX = 3 ' ||
1272: ' AND D.LIST_ENTRY_ID = A.LIST_ENTRY_ID ' ||
1273: ' AND D.LIST_ID = A.LIST_HEADER_ID ) ' ||
1274: ' , A.REASON_CODE_S4 = ( SELECT /*+ index(E iec_o_transition_phones_u1) */ E.ITM_CC_TZ_ID ' ||
1275: ' FROM IEC_O_TRANSITION_PHONES E' ||
1276: ' WHERE E.PHONE_INDEX = 4 ' ||
1277: ' AND E.LIST_ENTRY_ID = A.LIST_ENTRY_ID ' ||
1278: ' AND E.LIST_ID = A.LIST_HEADER_ID ) ' ||
1279: ' , A.REASON_CODE_S5 = ( SELECT /*+ index(F iec_o_transition_phones_u1) */ F.ITM_CC_TZ_ID ' ||

Line 1279: ' , A.REASON_CODE_S5 = ( SELECT /+ index(F iec_o_transition_phones_u1) / F.ITM_CC_TZ_ID ' ||

1275: ' FROM IEC_O_TRANSITION_PHONES E' ||
1276: ' WHERE E.PHONE_INDEX = 4 ' ||
1277: ' AND E.LIST_ENTRY_ID = A.LIST_ENTRY_ID ' ||
1278: ' AND E.LIST_ID = A.LIST_HEADER_ID ) ' ||
1279: ' , A.REASON_CODE_S5 = ( SELECT /*+ index(F iec_o_transition_phones_u1) */ F.ITM_CC_TZ_ID ' ||
1280: ' FROM IEC_O_TRANSITION_PHONES F' ||
1281: ' WHERE F.PHONE_INDEX = 5 ' ||
1282: ' AND F.LIST_ENTRY_ID = A.LIST_ENTRY_ID ' ||
1283: ' AND F.LIST_ID = A.LIST_HEADER_ID ) ' ||

Line 1280: ' FROM IEC_O_TRANSITION_PHONES F' ||

1276: ' WHERE E.PHONE_INDEX = 4 ' ||
1277: ' AND E.LIST_ENTRY_ID = A.LIST_ENTRY_ID ' ||
1278: ' AND E.LIST_ID = A.LIST_HEADER_ID ) ' ||
1279: ' , A.REASON_CODE_S5 = ( SELECT /*+ index(F iec_o_transition_phones_u1) */ F.ITM_CC_TZ_ID ' ||
1280: ' FROM IEC_O_TRANSITION_PHONES F' ||
1281: ' WHERE F.PHONE_INDEX = 5 ' ||
1282: ' AND F.LIST_ENTRY_ID = A.LIST_ENTRY_ID ' ||
1283: ' AND F.LIST_ID = A.LIST_HEADER_ID ) ' ||
1284: ' , A.REASON_CODE_S6 = ( SELECT /*+ index(G iec_o_transition_phones_u1) */ G.ITM_CC_TZ_ID ' ||

Line 1284: ' , A.REASON_CODE_S6 = ( SELECT /+ index(G iec_o_transition_phones_u1) / G.ITM_CC_TZ_ID ' ||

1280: ' FROM IEC_O_TRANSITION_PHONES F' ||
1281: ' WHERE F.PHONE_INDEX = 5 ' ||
1282: ' AND F.LIST_ENTRY_ID = A.LIST_ENTRY_ID ' ||
1283: ' AND F.LIST_ID = A.LIST_HEADER_ID ) ' ||
1284: ' , A.REASON_CODE_S6 = ( SELECT /*+ index(G iec_o_transition_phones_u1) */ G.ITM_CC_TZ_ID ' ||
1285: ' FROM IEC_O_TRANSITION_PHONES G' ||
1286: ' WHERE G.PHONE_INDEX = 6 ' ||
1287: ' AND G.LIST_ENTRY_ID = A.LIST_ENTRY_ID ' ||
1288: ' AND G.LIST_ID = A.LIST_HEADER_ID ) ' ||

Line 1285: ' FROM IEC_O_TRANSITION_PHONES G' ||

1281: ' WHERE F.PHONE_INDEX = 5 ' ||
1282: ' AND F.LIST_ENTRY_ID = A.LIST_ENTRY_ID ' ||
1283: ' AND F.LIST_ID = A.LIST_HEADER_ID ) ' ||
1284: ' , A.REASON_CODE_S6 = ( SELECT /*+ index(G iec_o_transition_phones_u1) */ G.ITM_CC_TZ_ID ' ||
1285: ' FROM IEC_O_TRANSITION_PHONES G' ||
1286: ' WHERE G.PHONE_INDEX = 6 ' ||
1287: ' AND G.LIST_ENTRY_ID = A.LIST_ENTRY_ID ' ||
1288: ' AND G.LIST_ID = A.LIST_HEADER_ID ) ' ||
1289: 'WHERE A.LIST_ENTRY_ID IN (SELECT H.LIST_ENTRY_ID ' ||

Line 2156: EXECUTE IMMEDIATE 'DELETE FROM iec_o_transition_phones where list_id = :1'

2152: -- phone number entry table. First we make sure the
2153: -- phone number transition table is cleared of all
2154: -- entries that pertain to this target group.
2155: ----------------------------------------------------------------
2156: EXECUTE IMMEDIATE 'DELETE FROM iec_o_transition_phones where list_id = :1'
2157: USING P_TARGET_GROUP_ID;
2158:
2159: ----------------------------------------------------------------
2160: -- Need to get all of the unique calling zones of the moved entries

Line 2241: INSERT INTO iec_o_transition_phones

2237: ----------------------------------------------------------------
2238: IF l_phone_entry_tbl.COUNT > 0
2239: THEN
2240: FORALL j IN l_phone_entry_tbl.FIRST..l_phone_entry_tbl.LAST
2241: INSERT INTO iec_o_transition_phones
2242: ( LIST_ID
2243: , LIST_ENTRY_ID
2244: , SUBSET_ID
2245: , territory_code

Line 2282: ' from iec_o_transition_phones c where c.list_id = :listID ' ||

2278: ' select IEC_G_MKTG_ITEM_CC_TZS_S.NEXTVAL, :listID, :schedID ' ||
2279: ', a.territory_code, a.timezone_id, NULL, ''N'', 0, -1 ' ||
2280: ', SYSDATE, 0, a.region_code, a.subset_id from ' ||
2281: ' (SELECT DISTINCT DECODE(region_id, -1, NULL, region_id) region_code, territory_code, subset_id, timezone_id '||
2282: ' from iec_o_transition_phones c where c.list_id = :listID ' ||
2283: ' and territory_code <> ''-1'' and timezone_id <> -1 ' ||
2284: ' and not exists (select null from iec_g_mktg_item_Cc_Tzs b where ' ||
2285: ' c.subset_id = b.subset_id and c.territory_code = b.territory_code ' ||
2286: ' and NVL(b.region_id, -1) = c.region_id and c.timezone_id = b.timezone_id ' ||

Line 2296: EXECUTE IMMEDIATE 'UPDATE IEC_O_TRANSITION_PHONES A SET A.ITM_CC_TZ_ID = ' ||

2292: ----------------------------------------------------------------
2293: -- Updating the temporary
2294: -- phones table with the callable zones cross reference id.
2295: ----------------------------------------------------------------
2296: EXECUTE IMMEDIATE 'UPDATE IEC_O_TRANSITION_PHONES A SET A.ITM_CC_TZ_ID = ' ||
2297: '( SELECT B.ITM_CC_TZ_ID FROM IEC_G_MKTG_ITEM_CC_TZS B ' ||
2298: ' WHERE B.LIST_HEADER_ID = A.LIST_ID AND B.SUBSET_ID = A.SUBSET_ID ' ||
2299: ' AND B.TERRITORY_CODE = A.TERRITORY_CODE AND B.TIMEZONE_ID = A.TIMEZONE_ID ' ||
2300: ' AND NVL(B.REGION_ID, -1) = A.REGION_ID) WHERE A.LIST_ID = :listID ' ||