DBA Data[Home] [Help]

APPS.JMF_SHIKYU_GRP dependencies on JMF_SHIKYU_REPLENISHMENTS

Line 730: -- enabled Replenishment SO Line stored in the JMF_SHIKYU_REPLENISHMENTS

726: x_return_status := FND_API.G_RET_STS_SUCCESS;
727: -- End API initialization
728:
729: -- Returns 1 if the passed in Sales Order Line ID corresponds to a SHIKYU
730: -- enabled Replenishment SO Line stored in the JMF_SHIKYU_REPLENISHMENTS
731: -- table, or an SO Line splitted from a Replenishment SO Line
732: SELECT count('x')
733: INTO l_shikyu_enabled_so_line_count
734: FROM dual

Line 739: jmf_shikyu_replenishments jsr

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
742: AND msib.subcontracting_component in (1, 2)
743: AND jsr.replenishment_so_line_id = oola.line_id