[Home] [Help]
1309: p_item_id IN NUMBER) RETURN NUMBER IS
1310:
1311: CURSOR ISSUED_VALUES_C IS
1312: SELECT NVL(SUM(NVL(wip.quantity_issued,0)),0)
1313: FROM mrp_wip_components wip
1314: WHERE wip.compile_designator = p_designator
1315: AND wip.organization_id = p_org_id
1316: AND wip.wip_entity_type in (1,3)
1317: AND DECODE(wip.wip_entity_type,1,1,wip.supply_demand_type) =