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.AMS_TCOP_PREVIEW dependencies on AMS_TCOP_PRVW_CONTACTS

Line 514: FROM AMS_TCOP_PRVW_CONTACTS CONTACT,

510: )
511: IS
512: SELECT /*+ leading(party_list) +*/
513: CONTACT.PARTY_ID, COUNT(CONTACT.PARTY_ID)
514: FROM AMS_TCOP_PRVW_CONTACTS CONTACT,
515: (SELECT COLUMN_VALUE PARTY_ID
516: FROM TABLE(CAST(p_contact_party_list as JTF_NUMBER_TABLE))
517: ) party_list
518: WHERE CONTACT.PARTY_ID = PARTY_LIST.PARTY_ID

Line 550: FROM AMS_TCOP_PRVW_CONTACTS CONTACT,

546: )
547: IS
548: SELECT /*+ leading(party_list) +*/
549: CONTACT.PARTY_ID, COUNT(CONTACT.PARTY_ID)
550: FROM AMS_TCOP_PRVW_CONTACTS CONTACT,
551: AMS_CAMPAIGN_SCHEDULES_B CSCH,
552: (SELECT COLUMN_VALUE PARTY_ID
553: FROM TABLE(CAST(p_contact_party_list as JTF_NUMBER_TABLE))
554: ) party_list

Line 575: SELECT AMS_TCOP_PRVW_CONTACTS_S.NEXTVAL

571: WHERE party_list.party_id=p_party_id;
572:
573: CURSOR C_GET_NEXT_PRVW_CONTACT
574: IS
575: SELECT AMS_TCOP_PRVW_CONTACTS_S.NEXTVAL
576: FROM DUAL;
577:
578:
579: l_schedule_id_list NUMBER_TABLE;

Line 1049: -- Create Contacts in AMS_TCOP_PRVW_CONTACTS

1045: l_contact_id_list(i) := l_contact_id;
1046:
1047: END LOOP;
1048:
1049: -- Create Contacts in AMS_TCOP_PRVW_CONTACTS
1050: FORALL i in l_contact_party_list.FIRST .. l_contact_party_list.LAST
1051: INSERT INTO
1052: AMS_TCOP_PRVW_CONTACTS
1053: (

Line 1052: AMS_TCOP_PRVW_CONTACTS

1048:
1049: -- Create Contacts in AMS_TCOP_PRVW_CONTACTS
1050: FORALL i in l_contact_party_list.FIRST .. l_contact_party_list.LAST
1051: INSERT INTO
1052: AMS_TCOP_PRVW_CONTACTS
1053: (
1054: CONTACT_ID,
1055: SCHEDULE_ID,
1056: PARTY_ID,

Line 1153: FROM AMS_TCOP_PRVW_CONTACTS CONTACT,

1149: CURSOR C_GET_GLOBAL_SIMULATED_CONTACT(p_start_date date,p_end_date date)
1150: IS
1151: SELECT /*+ leading(party_list) +*/
1152: CONTACT.PARTY_ID,COUNT(CONTACT.PARTY_ID)
1153: FROM AMS_TCOP_PRVW_CONTACTS CONTACT,
1154: (SELECT column_value party_id
1155: FROM TABLE(CAST(G_PARTY_LIST as JTF_NUMBER_TABLE))
1156: ) party_list
1157: WHERE CONTACT.PARTY_ID = party_list.PARTY_ID

Line 1168: FROM AMS_TCOP_PRVW_CONTACTS CONTACT,

1164: )
1165: IS
1166: SELECT /*+ leading(party_list) +*/
1167: CONTACT.PARTY_ID,COUNT(CONTACT.PARTY_ID)
1168: FROM AMS_TCOP_PRVW_CONTACTS CONTACT,
1169: AMS_CAMPAIGN_SCHEDULES_B CSCH,
1170: (SELECT column_value party_id
1171: FROM TABLE(CAST(G_PARTY_LIST as JTF_NUMBER_TABLE))
1172: ) party_list

Line 1231: FROM AMS_TCOP_PRVW_CONTACTS CONTACT,

1227: )
1228: IS
1229: SELECT /*+ leading(party_list) +*/
1230: CONTACT.PARTY_ID,CONTACT.SCHEDULE_ID
1231: FROM AMS_TCOP_PRVW_CONTACTS CONTACT,
1232: (SELECT column_value party_id
1233: FROM TABLE(CAST(p_fatigue_party_list as JTF_NUMBER_TABLE))
1234: ) party_list
1235: WHERE CONTACT.PARTY_ID = party_list.PARTY_ID

Line 1245: FROM AMS_TCOP_PRVW_CONTACTS CONTACT,

1241: )
1242: IS
1243: SELECT /*+ leading(party_list) +*/
1244: CONTACT.PARTY_ID,CONTACT.SCHEDULE_ID
1245: FROM AMS_TCOP_PRVW_CONTACTS CONTACT,
1246: AMS_CAMPAIGN_SCHEDULES_B CSCH,
1247: (SELECT column_value party_id
1248: FROM TABLE(CAST(p_fatigue_party_list as JTF_NUMBER_TABLE))
1249: ) party_list

Line 1294: FROM AMS_TCOP_PRVW_CONTACTS

1290: p_row_num number
1291: )
1292: IS
1293: SELECT SCHEDULE_ID
1294: FROM AMS_TCOP_PRVW_CONTACTS
1295: WHERE CONTACT_DATE BETWEEN p_start_date and p_end_date
1296: AND party_id = p_party_id
1297: AND PREVIEW_ID = G_PRVW_REQUEST_ID
1298: AND rownum = p_row_num

Line 1308: FROM AMS_TCOP_PRVW_CONTACTS CONTACT,

1304: p_row_num number
1305: )
1306: IS
1307: SELECT CONTACT.SCHEDULE_ID
1308: FROM AMS_TCOP_PRVW_CONTACTS CONTACT,
1309: AMS_CAMPAIGN_SCHEDULES_B CSCH
1310: WHERE CONTACT.CONTACT_DATE BETWEEN p_start_date and p_end_date
1311: AND CSCH.SCHEDULE_ID = CONTACT.SCHEDULE_ID
1312: AND CSCH.ACTIVITY_ID = G_ACTIVITY_ID

Line 1490: -- Now, use the simulated information stored in AMS_TCOP_PRVW_CONTACTS

1486:
1487: END IF;
1488:
1489: END IF;
1490: -- Now, use the simulated information stored in AMS_TCOP_PRVW_CONTACTS
1491: -- to verify the contact information
1492: IF ( NOT(G_NO_SCHEDULE_PIPELINE) ) THEN
1493:
1494: OPEN C_GET_GLOBAL_SIMULATED_CONTACT(l_global_fatigue_start_date,

Line 1534: -- AMS_TCOP_PRVW_CONTACTS

1530: -- this entry is fatigued
1531: -- now, find out the fatigued by
1532: -- it will be a combination of schedules
1533: -- in AMS_TCOP_CONTACTS and
1534: -- AMS_TCOP_PRVW_CONTACTS
1535: OPEN GET_SCHEDULE_FROM_CONTACTS
1536: (l_party_id,
1537: l_global_fatigue_start_date,
1538: sysdate

Line 1796: -- Now, use the simulated information stored in AMS_TCOP_PRVW_CONTACTS

1792: END IF;
1793:
1794: END IF;
1795:
1796: -- Now, use the simulated information stored in AMS_TCOP_PRVW_CONTACTS
1797: -- to verify the contact information
1798: IF ( NOT(G_NO_SCHEDULE_PIPELINE) ) THEN
1799:
1800: OPEN C_GET_CHNL_SIMULATED_CONTACT(l_channel_fatigue_start_date,

Line 1841: -- AMS_TCOP_PRVW_CONTACTS

1837: -- this entry is fatigued
1838: -- now, find out the fatigued by
1839: -- it will be a combination of schedules
1840: -- in AMS_TCOP_CONTACTS and
1841: -- AMS_TCOP_PRVW_CONTACTS
1842: OPEN GET_CSCH_FROM_CONTACTS_CHNL
1843: (l_party_id,
1844: l_channel_fatigue_start_date,
1845: sysdate

Line 2369: DELETE FROM AMS_TCOP_PRVW_CONTACTS

2365: LAST_UPDATE_DATE = sysdate,
2366: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
2367: WHERE REQUEST_ID=G_PRVW_REQUEST_ID;
2368:
2369: DELETE FROM AMS_TCOP_PRVW_CONTACTS
2370: WHERE PREVIEW_ID = G_PRVW_REQUEST_ID;
2371:
2372: DELETE FROM AMS_TCOP_PRVW_FATIGUE
2373: WHERE