DBA Data[Home] [Help]

APPS.JMF_SHIKYU_GRP dependencies on JMF_SHIKYU_REPLENISHMENTS

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

744: x_return_status := FND_API.G_RET_STS_SUCCESS;
745: -- End API initialization
746:
747: -- Returns 1 if the passed in Sales Order Line ID corresponds to a SHIKYU
748: -- enabled Replenishment SO Line stored in the JMF_SHIKYU_REPLENISHMENTS
749: -- table, or an SO Line splitted from a Replenishment SO Line
750: SELECT count('x')
751: INTO l_shikyu_enabled_so_line_count
752: FROM dual

Line 757: jmf_shikyu_replenishments jsr

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