APPS.EAM_MAT_REQ_VALIDATE_PVT dependencies on WIP_DISCRETE_JOBS

Line 672: from wip_discrete_jobs

668: begin
669:
670: select material_issue_by_mo
671: into l_material_issue_by_mo
672: from wip_discrete_jobs
673: where organization_id=p_eam_mat_req_rec.organization_id
674: and wip_entity_id=p_eam_mat_req_rec.wip_entity_id;
675:
676: if l_material_issue_by_mo='Y' and p_eam_mat_req_rec.required_quantity < nvl(p_eam_mat_req_rec.quantity_issued,0)+ nvl(l_allocated,0) then