DBA Data[Home] [Help]

APPS.JMF_SHIKYU_GRP dependencies on OE_ORDER_LINES_ALL

Line 755: FROM oe_order_lines_all oola,

751: INTO l_shikyu_enabled_so_line_count
752: FROM dual
753: WHERE exists
754: (SELECT 'X'
755: FROM oe_order_lines_all oola,
756: mtl_system_items_b msib,
757: jmf_shikyu_replenishments jsr
758: WHERE oola.inventory_item_id = msib.inventory_item_id
759: AND msib.organization_id = jsr.oem_organization_id

Line 764: FROM oe_order_lines_all

760: AND msib.subcontracting_component in (1, 2)
761: AND jsr.replenishment_so_line_id = oola.line_id
762: AND jsr.replenishment_so_line_id IN
763: (SELECT reference_line_id
764: FROM oe_order_lines_all
765: WHERE line_id = p_sales_order_line_id
766: )
767: );
768: