APPS.WIP_EAMWORKORDER_PVT SQL Statements

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

Line: 115

	 SELECT msib.eam_item_type into l_eam_item_type
         FROM
	 csi_item_instances cii, mtl_system_items_b msib, mtl_parameters mp
	 WHERE
	 msib.organization_id = mp.organization_id and
	 msib.organization_id = cii.last_vld_organization_id and
         msib.inventory_item_id = cii.inventory_item_id and
         msib.eam_item_type in (1,3) and
         msib.serial_number_control_code <> 1 and
         sysdate between nvl(cii.active_start_date, sysdate-1)
                and nvl(cii.active_end_date, sysdate+1) and
         mp.maint_organization_id = p_work_order_rec.organization_id and
         cii.instance_id = p_work_order_rec.maintenance_object_id;

Line: 140

		SELECT   cii.inventory_item_id,
		cii.serial_number
		INTO
		l_asset_group_id,
		l_asset_number
		FROM
		csi_item_instances cii
		WHERE
		cii.instance_id = p_work_order_rec.maintenance_object_id;

Line: 152

	        SELECT   cii.inventory_item_id,
		cii.serial_number
		INTO
		l_rebuild_item_id,
		l_rebuild_serial_number
		FROM
		csi_item_instances cii
		WHERE
		cii.instance_id = p_work_order_rec.maintenance_object_id;

Line: 175

           SELECT instance_id into l_gen_object_id
	     FROM csi_item_instances
	      WHERE inventory_item_id = p_work_order_rec.asset_group_id and serial_number = p_work_order_rec.asset_number and last_vld_organization_id =p_work_order_rec.organization_id  ;

Line: 190

	     select instance_id into l_gen_object_id
	       from csi_item_instances
	        where inventory_item_id = p_work_order_rec.rebuild_item_id and serial_number = p_work_order_rec.rebuild_serial_number and last_vld_organization_id =p_work_order_rec.organization_id;

Line: 204

		SELECT inventory_item_id into l_gen_object_id
		  FROM mtl_system_items
	             WHERE inventory_item_id = p_work_order_rec.rebuild_item_id  and organization_id =p_work_order_rec.organization_id;

Line: 250

  	  SELECT department_id into l_dept_id
   FROM bom_departments
   WHERE department_code =  p_work_order_rec.owning_department_code and organization_id= p_work_order_rec.organization_id;

Line: 487

            SELECT  MEAA.activity_cause_code
            INTO    x_activity_cause_code
            FROM    MTL_EAM_ASSET_ACTIVITIES MEAA
            WHERE   MEAA.organization_id    = p_organization_id
            AND     MEAA.asset_activity_id        = p_primary_item_id
            AND     MEAA.maintenance_object_id = p_maintenance_object_id
            AND     MEAA.maintenance_object_type = p_maintenance_object_type
            AND     NVL(MEAA.tmpl_flag,'N') = 'N';

Line: 504

            /*SELECT  MEAA.activity_cause_code
            INTO    x_activity_cause_code
            FROM    MTL_EAM_ASSET_ACTIVITIES MEAA
            WHERE   MEAA.organization_id    = p_organization_id
            AND     MEAA.asset_activity_id  = p_primary_item_id
            AND     MEAA.maintenance_object_id = p_rebuild_item_id
            AND     MEAA.maintenance_object_type = 2 ;-- 'MSI'*/

Line: 511

            SELECT eomd.activity_cause_code
            INTO    x_activity_cause_code
            FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA
            WHERE eomd.organization_id=p_organization_id
            AND eomd.object_type = 60
            AND eomd.object_id = meaa.activity_association_id
            AND MEAA.asset_activity_id  = p_primary_item_id
            AND MEAA.maintenance_object_id = p_maintenance_object_id
            AND MEAA.maintenance_object_type = 3 ;

Line: 532

            SELECT  MSI.eam_activity_cause_code
            INTO    x_activity_cause_code
            FROM    MTL_SYSTEM_ITEMS MSI
            WHERE   MSI.inventory_item_id = p_primary_item_id
            AND     MSI.organization_id = p_organization_id;

Line: 608

			SELECT value
			INTO   l_full_path
			FROM   v$parameter
			WHERE  name = 'utl_file_dir';

Line: 618

					    SELECT trim(substr(l_full_path, 1, decode(instr(l_full_path,',')-1,
											  -1, length(l_full_path),
											  instr(l_full_path, ',')-1
											 )
								  )
							   )
					    INTO  l_file_dir
					    FROM  dual;

Line: 714

            SELECT  MEAA.activity_type_code
            INTO    x_activity_type_code
            FROM    MTL_EAM_ASSET_ACTIVITIES MEAA
            WHERE   MEAA.organization_id    = p_organization_id
            AND     MEAA.asset_activity_id        = p_primary_item_id
            AND     MEAA.maintenance_object_id = p_maintenance_object_id
            AND     MEAA.maintenance_object_type = p_maintenance_object_type
            AND     NVL(MEAA.tmpl_flag,'N') = 'N';

Line: 731

            /*SELECT  MEAA.activity_type_code
            INTO    x_activity_type_code
            FROM    MTL_EAM_ASSET_ACTIVITIES MEAA
            WHERE   MEAA.organization_id    = p_organization_id
            AND     MEAA.asset_activity_id  = p_primary_item_id
            AND     MEAA.maintenance_object_id = p_rebuild_item_id
            AND     MEAA.maintenance_object_type = 2 ;-- 'MSI'*/

Line: 738

             SELECT eomd.activity_type_code
            INTO    x_activity_type_code
            FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA
            WHERE eomd.organization_id=p_organization_id
            AND eomd.object_type = 60
            AND eomd.object_id = meaa.activity_association_id
            AND MEAA.asset_activity_id  = p_primary_item_id
            AND MEAA.maintenance_object_id = p_maintenance_object_id
            AND MEAA.maintenance_object_type = 3 ;

Line: 759

            SELECT  MSI.eam_activity_type_code
            INTO    x_activity_type_code
            FROM    MTL_SYSTEM_ITEMS MSI
            WHERE   MSI.inventory_item_id = p_primary_item_id
            AND     MSI.organization_id = p_organization_id;

Line: 865

            SELECT  MEAA.activity_source_code
            INTO    x_activity_source_code
            FROM    MTL_EAM_ASSET_ACTIVITIES MEAA
            WHERE   MEAA.organization_id    = p_organization_id
            AND     MEAA.asset_activity_id        = p_primary_item_id
            AND     MEAA.maintenance_object_id = p_maintenance_object_id
            AND     MEAA.maintenance_object_type = p_maintenance_object_type
            AND     NVL(MEAA.tmpl_flag,'N') = 'N';

Line: 882

           /* SELECT  MEAA.activity_source_code
            INTO    x_activity_source_code
            FROM    MTL_EAM_ASSET_ACTIVITIES MEAA
            WHERE   MEAA.organization_id    = p_organization_id
            AND     MEAA.asset_activity_id  = p_primary_item_id
            AND     MEAA.maintenance_object_id = p_rebuild_item_id
            AND     MEAA.maintenance_object_type = 2 ;-- 'MSI'*/

Line: 889

            SELECT eomd.activity_source_code
            INTO    x_activity_source_code
            FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA
            WHERE eomd.organization_id=p_organization_id
            AND eomd.object_type = 60
            AND eomd.object_id = meaa.activity_association_id
            AND MEAA.asset_activity_id  = p_primary_item_id
            AND MEAA.maintenance_object_id = p_maintenance_object_id
            AND MEAA.maintenance_object_type = 3 ;

Line: 910

            SELECT  MSI.eam_activity_source_code
            INTO    x_activity_source_code
            FROM    MTL_SYSTEM_ITEMS MSI
            WHERE   MSI.inventory_item_id = p_primary_item_id
            AND     MSI.organization_id = p_organization_id;

Line: 1015

            SELECT  MEAA.shutdown_type_code
            INTO    x_shutdown_type_code
            FROM    MTL_EAM_ASSET_ACTIVITIES MEAA
            WHERE   MEAA.organization_id    = p_organization_id
            AND     MEAA.asset_activity_id        = p_primary_item_id
            AND     MEAA.maintenance_object_id = p_maintenance_object_id
            AND     MEAA.maintenance_object_type = p_maintenance_object_type
            AND     NVL(MEAA.tmpl_flag,'N') = 'N';

Line: 1032

           /* SELECT  MEAA.shutdown_type_code
            INTO    x_shutdown_type_code
            FROM    MTL_EAM_ASSET_ACTIVITIES MEAA
            WHERE   MEAA.organization_id    = p_organization_id
            AND     MEAA.asset_activity_id  = p_primary_item_id
            AND     MEAA.maintenance_object_id = p_rebuild_item_id
            AND     MEAA.maintenance_object_type = 2 ;-- 'MSI'*/

Line: 1040

            SELECT eomd.shutdown_type_code
            INTO    x_shutdown_type_code
            FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA
            WHERE eomd.organization_id=p_organization_id
            AND eomd.object_type = 60
            AND eomd.object_id = meaa.activity_association_id
            AND MEAA.asset_activity_id  = p_primary_item_id
            AND MEAA.maintenance_object_id = p_maintenance_object_id
            AND MEAA.maintenance_object_type = 3 ;

Line: 1062

            SELECT  MSI.eam_act_shutdown_status
            INTO    x_shutdown_type_code
            FROM    MTL_SYSTEM_ITEMS MSI
            WHERE   MSI.inventory_item_id = p_primary_item_id
            AND     MSI.organization_id = p_organization_id;

Line: 1168

            SELECT  MEAA.notification_required
            INTO    x_notification_flag
            FROM    MTL_EAM_ASSET_ACTIVITIES MEAA
            WHERE   MEAA.organization_id    = p_organization_id
            AND     MEAA.asset_activity_id        = p_primary_item_id
            AND     MEAA.maintenance_object_id = p_maintenance_object_id
            AND     MEAA.maintenance_object_type = p_maintenance_object_type
            AND     NVL(MEAA.tmpl_flag,'N') = 'N';

Line: 1184

            SELECT  MEAA.notification_required
            INTO    x_notification_flag
            FROM    MTL_EAM_ASSET_ACTIVITIES MEAA
            WHERE   MEAA.organization_id    = p_organization_id
            AND     MEAA.asset_activity_id  = p_primary_item_id
            AND     MEAA.maintenance_object_id = p_rebuild_item_id
            AND     MEAA.maintenance_object_type = 2 ;-- 'MSI'

Line: 1202

      SELECT eomd.notification_required
            INTO    x_notification_flag
            FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA
            WHERE eomd.organization_id=p_organization_id
            AND eomd.object_type = 60
            AND eomd.object_id = meaa.activity_association_id
            AND MEAA.asset_activity_id  = p_primary_item_id
            AND MEAA.maintenance_object_id = p_maintenance_object_id
            AND MEAA.maintenance_object_type = 3 ;

Line: 1220

            SELECT  MSI.eam_act_notification_flag
            INTO    x_notification_flag
            FROM    MTL_SYSTEM_ITEMS MSI
            WHERE   MSI.inventory_item_id = p_primary_item_id
            AND     MSI.organization_id = p_organization_id;

Line: 1326

            SELECT  MEAA.tagging_required_flag
            INTO    x_tagout_required
            FROM    MTL_EAM_ASSET_ACTIVITIES MEAA
            WHERE   MEAA.organization_id    = p_organization_id
            AND     MEAA.asset_activity_id        = p_primary_item_id
            AND     MEAA.maintenance_object_id = p_maintenance_object_id
            AND     MEAA.maintenance_object_type = p_maintenance_object_type
            AND     NVL(MEAA.tmpl_flag,'N') = 'N';

Line: 1343

            SELECT  MEAA.tagging_required_flag
            INTO    x_tagout_required
            FROM    MTL_EAM_ASSET_ACTIVITIES MEAA
            WHERE   MEAA.organization_id    = p_organization_id
            AND     MEAA.asset_activity_id  = p_primary_item_id
            AND     MEAA.maintenance_object_id = p_rebuild_item_id
            AND     MEAA.maintenance_object_type = 2 ;-- 'MSI'*/

Line: 1351

            SELECT eomd.tagging_required_flag
            INTO    x_tagout_required
            FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA
            WHERE eomd.organization_id=p_organization_id
            AND eomd.object_type = 60
            AND eomd.object_id = meaa.activity_association_id
            AND MEAA.asset_activity_id  = p_primary_item_id
            AND MEAA.maintenance_object_id = p_maintenance_object_id
            AND MEAA.maintenance_object_type = 3 ;

Line: 1464

            SELECT  MEAA.owning_department_id
            INTO    x_owning_department_id
            FROM    MTL_EAM_ASSET_ACTIVITIES MEAA
            WHERE   MEAA.asset_activity_id        = p_primary_item_id
            AND     MEAA.maintenance_object_id = p_maintenance_object_id
            AND     MEAA.maintenance_object_type = p_maintenance_object_type
            AND     NVL(MEAA.tmpl_flag,'N') = 'N';

Line: 1479

	    SELECT  MEAA.activity_association_id
            INTO    l_act_assoc_id
            FROM    MTL_EAM_ASSET_ACTIVITIES MEAA
            WHERE   MEAA.asset_activity_id     = p_primary_item_id
            AND     MEAA.maintenance_object_id = p_maintenance_object_id
            AND     MEAA.maintenance_object_type = p_maintenance_object_type
            AND     NVL(MEAA.tmpl_flag,'N') = 'N';

Line: 1487

	    SELECT  EOMD.OWNING_DEPARTMENT_ID
            INTO    x_owning_department_id
            FROM    EAM_ORG_MAINT_DEFAULTS EOMD
            WHERE   EOMD.organization_id    = p_organization_id
            AND     EOMD.OBJECT_ID  = l_act_assoc_id
            AND     EOMD.OBJECT_TYPE IN (40,60) ;

Line: 1504

            SELECT  EOMD.OWNING_DEPARTMENT_ID
            INTO    x_owning_department_id
            FROM    EAM_ORG_MAINT_DEFAULTS EOMD
            WHERE   EOMD.organization_id  = p_organization_id
            AND     EOMD.OBJECT_ID  = p_maintenance_object_id
            AND     EOMD.OBJECT_TYPE = 50 ;

Line: 1521

            SELECT  WEP.default_department_id
            INTO    x_owning_department_id
            FROM    WIP_EAM_PARAMETERS WEP
            WHERE   WEP.organization_id = p_organization_id;

Line: 1623

            SELECT eomd.work_order_type
            INTO   x_ACT_WO_Type
            FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA
            WHERE eomd.organization_id=p_organization_id
            AND eomd.object_type = 60
            AND eomd.object_id = meaa.activity_association_id
            AND MEAA.asset_activity_id  = p_primary_item_id
            AND MEAA.maintenance_object_id = p_maintenance_object_id
            AND MEAA.maintenance_object_type = 3 ;

Line: 1725

            SELECT eomd.planner_maintenance
            INTO   x_ACT_Planner
            FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA
            WHERE eomd.organization_id=p_organization_id
            AND eomd.object_type = 60
            AND eomd.object_id = meaa.activity_association_id
            AND MEAA.asset_activity_id  = p_primary_item_id
            AND MEAA.maintenance_object_id = p_maintenance_object_id
            AND MEAA.maintenance_object_type = 3 ;

Line: 1826

            SELECT eomd.firm_planned_flag
            INTO   x_ACT_Firm
            FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA
            WHERE eomd.organization_id=p_organization_id
            AND eomd.object_type = 60
            AND eomd.object_id = meaa.activity_association_id
            AND MEAA.asset_activity_id  = p_primary_item_id
            AND MEAA.maintenance_object_id = p_maintenance_object_id
            AND MEAA.maintenance_object_type = 3 ;

Line: 1927

            SELECT eomd.plan_maintenance
            INTO   x_ACT_Planned
            FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA
            WHERE eomd.organization_id=p_organization_id
            AND eomd.object_type = 60
            AND eomd.object_id = meaa.activity_association_id
            AND MEAA.asset_activity_id  = p_primary_item_id
            AND MEAA.maintenance_object_id = p_maintenance_object_id
            AND MEAA.maintenance_object_type = 3 ;