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.MSD_SR_UTIL dependencies on OE_ORDER_LINES_ALL

Line 649: from oe_order_lines_all

645:
646:
647: CURSOR c_parent_item IS
648: select component_sequence_id
649: from oe_order_lines_all
650: where line_id = p_parent_line_id;
651:
652:
653: /* The parent of optional item has to be

Line 774: from oe_order_lines_all

770:
771: CURSOR c_parent_id IS
772: select
773: inventory_item_id, item_type_code, link_to_line_id, ato_line_id
774: from oe_order_lines_all
775: where line_id = l_line_id;
776:
777: l_item_type_code VARCHAR2(10);
778: l_parent_item_id NUMBER := NULL;

Line 876: from oe_order_lines_all l

872: p_ato_line_id IN NUMBER) IS
873: select count(1)
874: from mtl_system_items itm
875: where inventory_item_id = (select inventory_item_id
876: from oe_order_lines_all l
877: where l.item_type_code = 'CONFIG'
878: and l.header_id = p_header_id
879: and l.org_id = p_org_id
880: and l.ato_line_id = p_ato_line_id )