APPS.AMS_TCOP_PREVIEW dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 400: /* Bug Fix 4990567: SQL ID 14423512. A new index AMS_CAMPAIGN_SCHEDULES_B_N13 was created */

396: )
397: IS
398: -- Cursor to get schedules in pipeline
399: /* Reverted changes for Bugfix: 4261272. Fix for SQL repository issue: 11756057 */
400: /* Bug Fix 4990567: SQL ID 14423512. A new index AMS_CAMPAIGN_SCHEDULES_B_N13 was created */
401: /* -- batoleti commented this cursor.
402: CURSOR C_GET_SCHEDULE_IN_PIPELINE
403: IS
404: SELECT CSCH.SCHEDULE_ID,CSCH.ACTIVITY_ID,CSCH.START_DATE_TIME

Line 405: FROM AMS_CAMPAIGN_SCHEDULES_B CSCH,

401: /* -- batoleti commented this cursor.
402: CURSOR C_GET_SCHEDULE_IN_PIPELINE
403: IS
404: SELECT CSCH.SCHEDULE_ID,CSCH.ACTIVITY_ID,CSCH.START_DATE_TIME
405: FROM AMS_CAMPAIGN_SCHEDULES_B CSCH,
406: AMS_ACT_LISTS ACT_LIST,
407: AMS_LIST_HEADERS_ALL LIST_HEADER
408: WHERE CSCH.START_DATE_TIME BETWEEN
409: p_preview_start_date AND p_preview_end_date

Line 433: FROM AMS_CAMPAIGN_SCHEDULES_B CSCH,

429: -- batoleti Ref. bug# 5234351... added leading(ACT_LIST) hint to the below query.
430: CURSOR C_GET_SCHEDULE_IN_PIPELINE
431: IS
432: SELECT /*+ leading(ACT_LIST) */ CSCH.SCHEDULE_ID,CSCH.ACTIVITY_ID,CSCH.START_DATE_TIME
433: FROM AMS_CAMPAIGN_SCHEDULES_B CSCH,
434: AMS_ACT_LISTS ACT_LIST,
435: AMS_LIST_HEADERS_ALL LIST_HEADER
436: WHERE TRUNC(CSCH.START_DATE_TIME) BETWEEN
437: p_preview_start_date AND p_preview_end_date

Line 463: ,AMS_CAMPAIGN_SCHEDULES_B CSCH

459: IS
460: SELECT LIST_ENTRY1.PARTY_ID
461: FROM AMS_LIST_ENTRIES LIST_ENTRY1
462: ,AMS_LIST_ENTRIES LIST_ENTRY2
463: ,AMS_CAMPAIGN_SCHEDULES_B CSCH
464: ,AMS_ACT_LISTS ACT_LIST
465: ,AMS_LIST_HEADERS_ALL LIST_HEADER
466: WHERE LIST_ENTRY1.LIST_HEADER_ID = p_list_header_id
467: AND LIST_ENTRY2.PARTY_ID = LIST_ENTRY1.PARTY_ID

Line 551: AMS_CAMPAIGN_SCHEDULES_B CSCH,

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
555: WHERE CONTACT.PARTY_ID = PARTY_LIST.PARTY_ID

Line 1169: AMS_CAMPAIGN_SCHEDULES_B CSCH,

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
1173: WHERE CONTACT.PARTY_ID = party_list.PARTY_ID

Line 1246: AMS_CAMPAIGN_SCHEDULES_B CSCH,

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
1250: WHERE CONTACT.PARTY_ID = party_list.PARTY_ID

Line 1309: AMS_CAMPAIGN_SCHEDULES_B CSCH

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
1313: AND CONTACT.party_id = p_party_id

Line 2200: FROM AMS_CAMPAIGN_SCHEDULES_B CSCH,

2196: -- Get Schedule Details
2197: CURSOR C_GET_SCHEDULE_DETAILS
2198: IS
2199: SELECT CSCH.SCHEDULE_ID,CSCH.START_DATE_TIME,CSCH.ACTIVITY_ID,CAMP.ACTUAL_EXEC_END_DATE
2200: FROM AMS_CAMPAIGN_SCHEDULES_B CSCH,
2201: AMS_ACT_LISTS ACT_LIST,ams_campaigns_vl CAMP
2202: WHERE ACT_LIST.LIST_HEADER_ID = p_list_header_id
2203: AND CSCH.SCHEDULE_ID = ACT_LIST.LIST_USED_BY_ID
2204: AND ACT_LIST.LIST_USED_BY = 'CSCH'