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.OTA_TDB_BUS dependencies on PER_LETTER_GEN_STATUSES

Line 2770: from per_letter_gen_statuses a,

2766:
2767: Cursor c_letter_requests_evt(cp_status_id in number) is
2768: select b.letter_type_id,
2769: c.letter_request_id
2770: from per_letter_gen_statuses a,
2771: per_letter_types b,
2772: per_letter_requests c
2773: where a.assignment_status_type_id = p_booking_status_type_id
2774: and b.letter_type_id = a.letter_type_id

Line 2785: from per_letter_gen_statuses a,

2781:
2782: Cursor c_letter_requests(cp_status_id in number) is
2783: select b.letter_type_id,
2784: c.letter_request_id
2785: from per_letter_gen_statuses a,
2786: per_letter_types b,
2787: per_letter_requests c
2788: where a.assignment_status_type_id = p_booking_status_type_id
2789: and b.letter_type_id = a.letter_type_id

Line 2799: from per_letter_gen_statuses a,

2795: and a.enabled_flag='Y'; ---***added for bug#2791524;
2796: --
2797: CURSOR c_letters (cp_status_id in number) IS
2798: select a.letter_type_id
2799: from per_letter_gen_statuses a,
2800: per_letter_types b
2801: where a.assignment_status_type_id = cp_status_id
2802: and b.letter_type_id = a.letter_type_id
2803: and b.generation_status_type = 'OTA_BOOKING'

Line 2915: from per_letter_gen_statuses a

2911: --
2912: CURSOR c_letters (cp_status_id in number) IS
2913: select a.letter_type_id
2914: , a.business_group_id
2915: from per_letter_gen_statuses a
2916: , per_letter_types b
2917: where a.assignment_status_type_id = cp_status_id
2918: and b.letter_type_id = a.letter_type_id
2919: and b.generation_status_type = 'OTA_BOOKING';