APPS.EAM_MAT_REQ_VALIDATE_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 627: from wip_requirement_operations

623: end if;
624:
625: select quantity_issued
626: into l_issued_qty
627: from wip_requirement_operations
628: where wip_entity_id = p_eam_mat_req_rec.wip_entity_id
629: and organization_id = p_eam_mat_req_rec.organization_id
630: and operation_seq_num = p_eam_mat_req_rec.operation_seq_num
631: and inventory_item_id = p_eam_mat_req_rec.inventory_item_id;

Line 726: FROM wip_requirement_operations wro, mtl_system_items_kfv msi

722: sum(Decode(upper(NVL(rqh.authorization_status, 'APPROVED')), 'CANCELLED', 0, 'REJECTED', 0, 'SYSTEM_SAVED',0,rql.quantity)) quantity
723: FROM (
724: SELECT
725: wro.wip_entity_id, wro.operation_seq_num, wro.organization_id, wro.inventory_item_id
726: FROM wip_requirement_operations wro, mtl_system_items_kfv msi
727: WHERE msi.inventory_item_id = wro.inventory_item_id
728: AND msi.organization_id = wro.organization_id
729: AND nvl(msi.stock_enabled_flag, 'N') = 'N'
730: )