APPS.EAM_WOREP_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 86

        l_sql_stmt := ' SELECT wdj.wip_entity_id
                        FROM wip_discrete_jobs wdj, eam_work_order_details ewod, csi_item_instances cii,wip_entities we,eam_org_maint_defaults eomd,
			mtl_eam_locations mel
                        WHERE wdj.wip_entity_id = ewod.wip_entity_id
                        AND decode(wdj.maintenance_object_type,3, wdj.maintenance_object_id,NULL) = cii.instance_id(+)
                        AND wdj.wip_entity_id = we.wip_entity_id
			AND wdj.organization_id=we.organization_id
			AND wdj.organization_id = :p_org_id
		        AND eomd.object_id(+) = cii.instance_id
			AND eomd.object_type(+)=50
			AND eomd.organization_id(+)=:p_org_id
			AND mel.location_id(+)=eomd.area_id';

Line: 129

                l_where_clause := l_where_clause || ' AND EXISTS (SELECT 1
                                                                    FROM wip_operations wo
                                                                   WHERE wo.wip_entity_id = wdj.wip_entity_id
								     AND wo.organization_id=wdj.organization_id
                                                                     AND wo.department_id = ' || p_assigned_department || ' ) ';