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_LIST_ENTRIES

Line 419: FROM AMS_LIST_ENTRIES LIST_ENTRY1

415: AND ACT_LIST.LIST_ACT_TYPE = 'TARGET'
416: AND LIST_HEADER.APPLY_TRAFFIC_COP = 'Y'
417: AND EXISTS
418: (SELECT LIST_ENTRY1.PARTY_ID
419: FROM AMS_LIST_ENTRIES LIST_ENTRY1
420: ,AMS_LIST_ENTRIES LIST_ENTRY2
421: WHERE LIST_HEADER.LIST_HEADER_ID = LIST_ENTRY1.LIST_HEADER_ID
422: AND LIST_ENTRY1.PARTY_ID = LIST_ENTRY2.PARTY_ID
423: AND LIST_ENTRY2.LIST_HEADER_ID = p_list_header_id

Line 420: ,AMS_LIST_ENTRIES LIST_ENTRY2

416: AND LIST_HEADER.APPLY_TRAFFIC_COP = 'Y'
417: AND EXISTS
418: (SELECT LIST_ENTRY1.PARTY_ID
419: FROM AMS_LIST_ENTRIES LIST_ENTRY1
420: ,AMS_LIST_ENTRIES LIST_ENTRY2
421: WHERE LIST_HEADER.LIST_HEADER_ID = LIST_ENTRY1.LIST_HEADER_ID
422: AND LIST_ENTRY1.PARTY_ID = LIST_ENTRY2.PARTY_ID
423: AND LIST_ENTRY2.LIST_HEADER_ID = p_list_header_id
424: )

Line 447: FROM AMS_LIST_ENTRIES LIST_ENTRY1

443: AND ACT_LIST.LIST_ACT_TYPE = 'TARGET'
444: AND LIST_HEADER.APPLY_TRAFFIC_COP = 'Y'
445: AND EXISTS
446: (SELECT LIST_ENTRY1.PARTY_ID
447: FROM AMS_LIST_ENTRIES LIST_ENTRY1
448: ,AMS_LIST_ENTRIES LIST_ENTRY2
449: WHERE LIST_HEADER.LIST_HEADER_ID = LIST_ENTRY1.LIST_HEADER_ID
450: AND LIST_ENTRY1.PARTY_ID = LIST_ENTRY2.PARTY_ID
451: AND LIST_ENTRY2.LIST_HEADER_ID = p_list_header_id

Line 448: ,AMS_LIST_ENTRIES LIST_ENTRY2

444: AND LIST_HEADER.APPLY_TRAFFIC_COP = 'Y'
445: AND EXISTS
446: (SELECT LIST_ENTRY1.PARTY_ID
447: FROM AMS_LIST_ENTRIES LIST_ENTRY1
448: ,AMS_LIST_ENTRIES LIST_ENTRY2
449: WHERE LIST_HEADER.LIST_HEADER_ID = LIST_ENTRY1.LIST_HEADER_ID
450: AND LIST_ENTRY1.PARTY_ID = LIST_ENTRY2.PARTY_ID
451: AND LIST_ENTRY2.LIST_HEADER_ID = p_list_header_id
452: )

Line 461: FROM AMS_LIST_ENTRIES LIST_ENTRY1

457: -- Get overlapping target group members for this schedule
458: CURSOR C_GET_OVERLAPPING_MEMBER(p_schedule_id NUMBER)
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

Line 462: ,AMS_LIST_ENTRIES LIST_ENTRY2

458: CURSOR C_GET_OVERLAPPING_MEMBER(p_schedule_id NUMBER)
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

Line 2212: FROM AMS_LIST_ENTRIES

2208: -- Get the list of party Ids to be previewed
2209: CURSOR C_GET_PARTY_LIST
2210: IS
2211: SELECT PARTY_ID
2212: FROM AMS_LIST_ENTRIES
2213: WHERE LIST_HEADER_ID = p_list_header_id
2214: AND ENABLED_FLAG='Y';
2215:
2216: -- Get Fatigue Rule Details

Line 2461: FROM AMS_LIST_ENTRIES

2457:
2458: CURSOR C_PREVIEW_SIZE (p_list_header_id NUMBER)
2459: IS
2460: SELECT COUNT(PARTY_ID)
2461: FROM AMS_LIST_ENTRIES
2462: WHERE LIST_HEADER_ID = p_list_header_id
2463: AND ENABLED_FLAG='Y';
2464:
2465: --Local Variables

Line 2540: FROM AMS_LIST_ENTRIES

2536:
2537: CURSOR C_PREVIEW_SIZE
2538: IS
2539: SELECT COUNT(PARTY_ID)
2540: FROM AMS_LIST_ENTRIES
2541: WHERE LIST_HEADER_ID = p_list_header_id
2542: AND ENABLED_FLAG='Y';
2543:
2544: l_total_preview_count NUMBER;

Line 2650: FROM AMS_LIST_ENTRIES

2646:
2647: CURSOR C_PREVIEW_SIZE
2648: IS
2649: SELECT COUNT(PARTY_ID)
2650: FROM AMS_LIST_ENTRIES
2651: WHERE LIST_HEADER_ID = p_list_header_id
2652: AND ENABLED_FLAG='Y';
2653:
2654: l_total_preview_count NUMBER;