APPS.JMF_SHIKYU_ADJUSTMENT_PROC dependencies on JMF_SHIKYU_ALLOCATIONS
Line 1453: FROM jmf_shikyu_allocations jsa
1449: SELECT SUM(jsa.allocated_quantity) --this meam the jsa.allocated_quantity is under Primary UOM
1450: ,MAX(jsa.uom)
1451: INTO l_total_allocated_qty
1452: ,l_total_allocated_uom 1453: FROM jmf_shikyu_allocations jsa 1454: WHERE jsa.subcontract_po_shipment_id = p_subcontract_po_shipment_id
1455: AND jsa.shikyu_component_id = p_component_id;
1456:
1457: IF l_wip_consumed_qty > l_total_allocated_qty