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

Line 737: FROM oe_order_lines_all oola,

733: INTO l_shikyu_enabled_so_line_count
734: FROM dual
735: WHERE exists
736: (SELECT 'X'
737: FROM oe_order_lines_all oola,
738: mtl_system_items_b msib,
739: jmf_shikyu_replenishments jsr
740: WHERE oola.inventory_item_id = msib.inventory_item_id
741: AND msib.organization_id = jsr.oem_organization_id

Line 746: FROM oe_order_lines_all

742: AND msib.subcontracting_component in (1, 2)
743: AND jsr.replenishment_so_line_id = oola.line_id
744: AND jsr.replenishment_so_line_id IN
745: (SELECT reference_line_id
746: FROM oe_order_lines_all
747: WHERE line_id = p_sales_order_line_id
748: )
749: );
750: