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 649: FROM wip_requirement_operations wro

645: AND (NVL(bc.disable_date,sysdate+1));
646: ELSE
647: SELECT wro.required_quantity
648: INTO l_quantity
649: FROM wip_requirement_operations wro
650: , jmf_subcontract_orders jso
651: WHERE wro.wip_entity_id = jso.wip_entity_id
652: AND wro.inventory_item_id = p_item_id
653: AND wro.organization_id = jso.tp_organization_id