APPS.JMF_SHIKYU_WIP_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 18: --| wip_requirement_operations instead of |

14: --| HISTORY |
15: --| 05/09/2005 pseshadr Created |
16: --| 12/14/2005 vchu Modified Get_Component_Quantity to return |
17: --| required_quantity from |
18: --| wip_requirement_operations instead of |
19: --| wro.required_quantity - wro.quantity_issued |
20: --| 03/27/2006 vchu Fixed bug 5090721: Set last_update_date, |
21: --| last_updated_by and last_update_login in the |
22: --| update statements. |

Line 747: FROM wip_requirement_operations wro

743: AND (NVL(bc.disable_date,sysdate+1));
744: ELSE
745: SELECT wro.required_quantity
746: INTO l_quantity
747: FROM wip_requirement_operations wro
748: , jmf_subcontract_orders jso
749: WHERE wro.wip_entity_id = jso.wip_entity_id
750: AND wro.inventory_item_id = p_item_id
751: AND wro.organization_id = jso.tp_organization_id