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 648: from oe_order_lines_all

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

Line 773: from oe_order_lines_all

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

Line 944: from oe_order_lines_all l

940: p_ato_line_id IN NUMBER) IS
941: select count(1)
942: from mtl_system_items itm
943: where inventory_item_id = (select inventory_item_id
944: from oe_order_lines_all l
945: where l.item_type_code = 'CONFIG'
946: and l.header_id = p_header_id
947: and l.org_id = p_org_id
948: and l.ato_line_id = p_ato_line_id )