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.OE_LIN dependencies on SO_LINE_SERVICE_DETAILS

Line 707: from SO_LINE_SERVICE_DETAILS

703: nvl(serv.cancelled_quantity,0) > 0
704: and lin.parent_line_id = x_line_id;
705: cursor installation_exists(x_line_id number) is
706: select line_id
707: from SO_LINE_SERVICE_DETAILS
708: where line_id = x_line_id
709: union
710: select lin.line_id
711: from SO_LINE_SERVICE_DETAILS isd, so_lines lin

Line 711: from SO_LINE_SERVICE_DETAILS isd, so_lines lin

707: from SO_LINE_SERVICE_DETAILS
708: where line_id = x_line_id
709: union
710: select lin.line_id
711: from SO_LINE_SERVICE_DETAILS isd, so_lines lin
712: where isd.line_id = lin.line_id
713: and lin.parent_line_id = x_line_id;
714: begin
715: open service_exists(p_line_id);

Line 741: from SO_LINE_SERVICE_DETAILS

737: and nvl(ordered_quantity,0) - nvl(cancelled_quantity,0) > 0;
738:
739: cursor installation_exists(x_line_id number) is
740: select line_id
741: from SO_LINE_SERVICE_DETAILS
742: where line_id = x_line_id;
743: begin
744: open service_exists(p_line_id);
745: fetch service_exists into l_dummy;