APPS.EAM_MAT_REQ_VALIDATE_PVT dependencies on WIP_DISCRETE_JOBS

Line 668: from wip_discrete_jobs

664: begin
665:
666: select material_issue_by_mo
667: into l_material_issue_by_mo
668: from wip_discrete_jobs
669: where organization_id=p_eam_mat_req_rec.organization_id
670: and wip_entity_id=p_eam_mat_req_rec.wip_entity_id;
671:
672: 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