APPS.EAM_MAT_REQ_VALIDATE_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 623: from wip_requirement_operations

619: end if;
620:
621: select quantity_issued
622: into l_issued_qty
623: from wip_requirement_operations
624: where wip_entity_id = p_eam_mat_req_rec.wip_entity_id
625: and organization_id = p_eam_mat_req_rec.organization_id
626: and operation_seq_num = p_eam_mat_req_rec.operation_seq_num
627: and inventory_item_id = p_eam_mat_req_rec.inventory_item_id;

Line 721: FROM wip_requirement_operations wro, mtl_system_items_kfv msi

717: sum(rql.quantity) quantity
718: FROM (
719: SELECT
720: wro.wip_entity_id, wro.operation_seq_num, wro.organization_id, wro.inventory_item_id
721: FROM wip_requirement_operations wro, mtl_system_items_kfv msi
722: WHERE msi.inventory_item_id = wro.inventory_item_id
723: AND msi.organization_id = wro.organization_id
724: AND nvl(msi.stock_enabled_flag, 'N') = 'N'
725: )