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.

[Home] [Help]

APPS.IRC_OFFERS_SWI dependencies on IRC_OFFER_STATUS_HISTORY

Line 2866: from irc_offer_status_history iosh1

2862: --
2863: cursor csr_offer_history_details(p_offer_id number) is
2864: select offer_status
2865: ,change_reason
2866: from irc_offer_status_history iosh1
2867: where iosh1.offer_id = p_offer_id
2868: and status_change_date = (select max(status_change_date)
2869: from irc_offer_status_history iosh2
2870: where iosh2.offer_id = p_offer_id);

Line 2869: from irc_offer_status_history iosh2

2865: ,change_reason
2866: from irc_offer_status_history iosh1
2867: where iosh1.offer_id = p_offer_id
2868: and status_change_date = (select max(status_change_date)
2869: from irc_offer_status_history iosh2
2870: where iosh2.offer_id = p_offer_id);
2871: --
2872: cursor csr_offer_status_before_hold is
2873: select ios1.offer_status

Line 2874: from irc_offer_status_history ios1

2870: where iosh2.offer_id = p_offer_id);
2871: --
2872: cursor csr_offer_status_before_hold is
2873: select ios1.offer_status
2874: from irc_offer_status_history ios1
2875: where ios1.offer_id = l_offer_id
2876: and 1 = (select count(*)
2877: from irc_offer_status_history ios2
2878: where ios2.offer_id = l_offer_id

Line 2877: from irc_offer_status_history ios2

2873: select ios1.offer_status
2874: from irc_offer_status_history ios1
2875: where ios1.offer_id = l_offer_id
2876: and 1 = (select count(*)
2877: from irc_offer_status_history ios2
2878: where ios2.offer_id = l_offer_id
2879: and ios2.offer_status_history_id > ios1.offer_status_history_id);
2880: --
2881: begin