APPS.JMF_SHIKYU_UTIL dependencies on JMF_SHIKYU_ALLOCATIONS

Line 984: FROM jmf_shikyu_allocations

980: BEGIN
981:
982: SELECT NVL(SUM(allocated_quantity), 0)
983: INTO l_allocated_qty
984: FROM jmf_shikyu_allocations
985: WHERE subcontract_po_shipment_id = p_subcontract_po_shipment_id
986: AND shikyu_component_id = p_component_id;
987:
988: RETURN l_allocated_qty;