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_ILEARNING2 dependencies on OTA_FINANCE_LINES

Line 54: l_finance_line_id OTA_FINANCE_LINES.FINANCE_LINE_ID%TYPE;

50:
51: l_proc varchar2(72) := g_package||'upd_history.';
52: l_booking_id OTA_DELEGATE_BOOKINGS.BOOKING_ID%TYPE;
53: l_ovn OTA_DELEGATE_BOOKINGS.OBJECT_VERSION_NUMBER%TYPE;
54: l_finance_line_id OTA_FINANCE_LINES.FINANCE_LINE_ID%TYPE;
55: l_tfl_finance_line_id OTA_FINANCE_LINES.FINANCE_LINE_ID%TYPE;
56: l_sequence_number OTA_FINANCE_LINES.SEQUENCE_NUMBER%TYPE;
57: l_fl_ovn OTA_FINANCE_LINES.OBJECT_VERSION_NUMBER%TYPE;
58: l_tfl_ovn OTA_FINANCE_LINES.OBJECT_VERSION_NUMBER%TYPE;

Line 55: l_tfl_finance_line_id OTA_FINANCE_LINES.FINANCE_LINE_ID%TYPE;

51: l_proc varchar2(72) := g_package||'upd_history.';
52: l_booking_id OTA_DELEGATE_BOOKINGS.BOOKING_ID%TYPE;
53: l_ovn OTA_DELEGATE_BOOKINGS.OBJECT_VERSION_NUMBER%TYPE;
54: l_finance_line_id OTA_FINANCE_LINES.FINANCE_LINE_ID%TYPE;
55: l_tfl_finance_line_id OTA_FINANCE_LINES.FINANCE_LINE_ID%TYPE;
56: l_sequence_number OTA_FINANCE_LINES.SEQUENCE_NUMBER%TYPE;
57: l_fl_ovn OTA_FINANCE_LINES.OBJECT_VERSION_NUMBER%TYPE;
58: l_tfl_ovn OTA_FINANCE_LINES.OBJECT_VERSION_NUMBER%TYPE;
59: l_date_raised OTA_FINANCE_LINES.DATE_RAISED%TYPE;

Line 56: l_sequence_number OTA_FINANCE_LINES.SEQUENCE_NUMBER%TYPE;

52: l_booking_id OTA_DELEGATE_BOOKINGS.BOOKING_ID%TYPE;
53: l_ovn OTA_DELEGATE_BOOKINGS.OBJECT_VERSION_NUMBER%TYPE;
54: l_finance_line_id OTA_FINANCE_LINES.FINANCE_LINE_ID%TYPE;
55: l_tfl_finance_line_id OTA_FINANCE_LINES.FINANCE_LINE_ID%TYPE;
56: l_sequence_number OTA_FINANCE_LINES.SEQUENCE_NUMBER%TYPE;
57: l_fl_ovn OTA_FINANCE_LINES.OBJECT_VERSION_NUMBER%TYPE;
58: l_tfl_ovn OTA_FINANCE_LINES.OBJECT_VERSION_NUMBER%TYPE;
59: l_date_raised OTA_FINANCE_LINES.DATE_RAISED%TYPE;
60: l_booking_status_type_id OTA_BOOKING_STATUS_TYPES.BOOKING_STATUS_TYPE_ID%TYPE;

Line 57: l_fl_ovn OTA_FINANCE_LINES.OBJECT_VERSION_NUMBER%TYPE;

53: l_ovn OTA_DELEGATE_BOOKINGS.OBJECT_VERSION_NUMBER%TYPE;
54: l_finance_line_id OTA_FINANCE_LINES.FINANCE_LINE_ID%TYPE;
55: l_tfl_finance_line_id OTA_FINANCE_LINES.FINANCE_LINE_ID%TYPE;
56: l_sequence_number OTA_FINANCE_LINES.SEQUENCE_NUMBER%TYPE;
57: l_fl_ovn OTA_FINANCE_LINES.OBJECT_VERSION_NUMBER%TYPE;
58: l_tfl_ovn OTA_FINANCE_LINES.OBJECT_VERSION_NUMBER%TYPE;
59: l_date_raised OTA_FINANCE_LINES.DATE_RAISED%TYPE;
60: l_booking_status_type_id OTA_BOOKING_STATUS_TYPES.BOOKING_STATUS_TYPE_ID%TYPE;
61:

Line 58: l_tfl_ovn OTA_FINANCE_LINES.OBJECT_VERSION_NUMBER%TYPE;

54: l_finance_line_id OTA_FINANCE_LINES.FINANCE_LINE_ID%TYPE;
55: l_tfl_finance_line_id OTA_FINANCE_LINES.FINANCE_LINE_ID%TYPE;
56: l_sequence_number OTA_FINANCE_LINES.SEQUENCE_NUMBER%TYPE;
57: l_fl_ovn OTA_FINANCE_LINES.OBJECT_VERSION_NUMBER%TYPE;
58: l_tfl_ovn OTA_FINANCE_LINES.OBJECT_VERSION_NUMBER%TYPE;
59: l_date_raised OTA_FINANCE_LINES.DATE_RAISED%TYPE;
60: l_booking_status_type_id OTA_BOOKING_STATUS_TYPES.BOOKING_STATUS_TYPE_ID%TYPE;
61:
62: l_cur_booking_status_type_id OTA_BOOKING_STATUS_TYPES.BOOKING_STATUS_TYPE_ID%TYPE;

Line 59: l_date_raised OTA_FINANCE_LINES.DATE_RAISED%TYPE;

55: l_tfl_finance_line_id OTA_FINANCE_LINES.FINANCE_LINE_ID%TYPE;
56: l_sequence_number OTA_FINANCE_LINES.SEQUENCE_NUMBER%TYPE;
57: l_fl_ovn OTA_FINANCE_LINES.OBJECT_VERSION_NUMBER%TYPE;
58: l_tfl_ovn OTA_FINANCE_LINES.OBJECT_VERSION_NUMBER%TYPE;
59: l_date_raised OTA_FINANCE_LINES.DATE_RAISED%TYPE;
60: l_booking_status_type_id OTA_BOOKING_STATUS_TYPES.BOOKING_STATUS_TYPE_ID%TYPE;
61:
62: l_cur_booking_status_type_id OTA_BOOKING_STATUS_TYPES.BOOKING_STATUS_TYPE_ID%TYPE;
63: l_cur_content_player_status OTA_DELEGATE_BOOKINGS.CONTENT_PLAYER_STATUS%TYPE;

Line 110: ota_finance_lines

106: sequence_number,
107: date_raised,
108: finance_header_id
109: from
110: ota_finance_lines
111: where
112: booking_id = l_booking_id and
113: cancelled_flag = 'N' and
114: transfer_status = 'NT';