APPS.EAM_ACTIVITYUTILITIES_PVT SQL Statements

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

Line: 43

			SELECT 	organization_code INTO x_organization_code
			FROM 	mtl_parameters
			WHERE 	organization_id = p_organization_id;

Line: 57

			SELECT	organization_id INTO x_organization_id
			FROM	mtl_parameters
			WHERE	organization_code = p_organization_code;

Line: 144

			SELECT	wip_entity_name,
				organization_id
			INTO 	l_x_work_order_rec.wip_entity_name,
				l_x_work_order_rec.organization_id
			FROM 	wip_entities
			WHERE	wip_entity_id = p_work_order_rec.wip_entity_id;

Line: 194

			SELECT 	wip_entity_id INTO l_x_work_order_rec.wip_entity_id
			FROM	wip_entities
			WHERE	organization_id = l_x_work_order_rec.organization_id
			 AND	wip_entity_name = l_x_work_order_rec.wip_entity_name;

Line: 271

		SELECT 	concatenated_segments INTO l_item_concatenated_segments
		FROM	MTL_SYSTEM_ITEMS_B_KFV
		WHERE	organization_id = p_organization_id
		 AND	inventory_item_id = p_inventory_item_id;

Line: 327

		SELECT	primary_item_id INTO l_activity_id
		FROM	wip_discrete_jobs
		WHERE	wip_entity_id = p_wip_entity_id;

Line: 366

		SELECT	organization_id INTO l_org_id
		FROM	wip_discrete_jobs
		WHERE	wip_entity_id = p_wip_entity_id;

Line: 405

		SELECT 	department_code INTO l_department_code
		FROM 	bom_departments
		WHERE	organization_id = p_organization_id
		and	department_id = p_department_id
		and 	(disable_date IS NULL
			or disable_date > sysdate);

Line: 448

		SELECT 	resource_code INTO l_resource_code
		FROM	bom_resources
		WHERE	organization_id = p_organization_id
		and	resource_id = p_resource_id
		and 	(disable_date IS NULL
			or disable_date > sysdate);

Line: 490

		SELECT	expense_account INTO l_expense_account_id
		FROM	mtl_parameters
		WHERE	organization_id = p_organization_id;

Line: 529

		SELECT 	asset_group_id, asset_number
		INTO 	x_inventory_item_id, x_serial_number
		FROM	wip_discrete_jobs
		WHERE	wip_entity_id = p_wip_entity_id;

Line: 568

		SELECT	owning_department_id INTO l_owning_dept_id
		FROM	mtl_serial_numbers
		WHERE	current_organization_id = p_organization_id
		AND	inventory_item_id = p_inventory_item_id
		AND	serial_number = p_serial_number;

Line: 615

		SELECT	scheduled_units INTO l_scheduled_units
		FROM	wip_operation_resources_v
		WHERE	organization_id = p_organization_id
		AND	wip_entity_id = p_wip_entity_id
		AND	operation_seq_num = p_operation_seq_num
		AND	resource_seq_num = p_resource_seq_num;

Line: 659

		SELECT 	master_organization_id INTO l_master_org_id
		FROM	mtl_parameters
		WHERE	organization_id = p_organization_id;

Line: 711

			SELECT 	instance_id, 3
			INTO	x_maintenance_object_id, x_maintenance_object_type
			FROM	csi_item_instances
			WHERE	instance_number = p_instance_number;

Line: 760

				SELECT 	instance_id, 3
				INTO	x_maintenance_object_id, x_maintenance_object_type
				FROM	csi_item_instances
				WHERE	inventory_item_id = p_inventory_item_id
				  AND	serial_number = p_serial_number;

Line: 791

				select	count(*) into l_count
				from	mtl_system_items
				where	inventory_item_id = p_inventory_item_id;

Line: 845

		SELECT	activity INTO l_activity
		FROM	cst_activities
		WHERE	activity_id = p_activity_id;

Line: 884

		SELECT	concatenated_segments INTO l_locator
		FROM	mtl_item_locations_kfv
		WHERE	organization_id = p_organization_id
		AND	subinventory_code = p_subinventory_code
		AND	(disable_date > sysdate or disable_date is null)
		AND	inventory_location_id = p_locator_id;

Line: 931

		SELECT 	x_pos, y_pos INTO x_x_pos, x_y_pos
		FROM	wip_operations
		WHERE	organization_id = p_organization_id
		AND	wip_entity_id = p_wip_entity_id
		AND	operation_seq_num = p_operation_seq_num;

Line: 974

		SELECT 	bill_sequence_id INTO l_bom_sequence_id
		FROM 	bom_bill_of_materials
		WHERE	organization_id = p_organization_id
		AND	assembly_item_id = p_assembly_item_id
		AND	( (alternate_bom_designator IS NULL AND p_alternate_bom_designator IS NULL)
 			  OR alternate_bom_designator = p_alternate_bom_designator);

Line: 1021

		SELECT 	routing_sequence_id INTO l_rtg_sequence_id
		FROM 	bom_operational_routings
		WHERE	organization_id = p_organization_id
		AND	assembly_item_id = p_assembly_item_id
		AND	( (alternate_routing_designator IS NULL AND p_alternate_rtg_designator IS NULL)
 			  OR alternate_routing_designator = p_alternate_rtg_designator);

Line: 1068

		SELECT	gen_object_id INTO l_gen_object_id
		FROM	mtl_serial_numbers
		WHERE	current_organization_id = p_organization_id
		AND	inventory_item_id = p_inventory_item_id
		AND	serial_number = p_serial_number;

Line: 1118

		SELECT 	organization_id, primary_item_id, maintenance_object_id, maintenance_object_type
		INTO	x_source_org_id, x_source_activity_id, x_wo_maint_id, x_wo_maint_type
		FROM 	wip_discrete_jobs
		WHERE	wip_entity_id = p_wip_entity_id;

Line: 1157

			SELECT owning_department_id
			INTO   l_owning_department_id
			FROM   eam_org_maint_defaults
			WHERE  object_id = p_activity_association_id AND object_type in (40, 60)
			  AND  organization_id = p_organization_id;

Line: 1174

			SELECT owning_department_id
			INTO   l_owning_department_id
			FROM   eam_org_maint_defaults
			WHERE  object_id = p_instance_id AND object_type = 50
			  AND  organization_id = p_organization_id;

Line: 1190

		SELECT	default_department_id
		INTO	l_owning_department_id
		FROM	wip_eam_parameters
		WHERE	organization_id = p_organization_id;

Line: 1239

		SELECT	msi.serial_number_control_code
		INTO	l_serial_number_control_code
		FROM	mtl_system_items msi, mtl_parameters mp
		WHERE	mp.maint_organization_id = p_organization_id
		AND	mp.organization_id = msi.organization_id
		AND	msi.inventory_item_id = p_maint_id
		AND	ROWNUM = 1;

Line: 1626

    select count(1) into l_count
    from bom_bill_of_materials
    where assembly_item_id = p_inventory_item_id and
    organization_id = p_org_id;

Line: 1645

    select count(1) into l_count
    from bom_operational_routings
    where assembly_item_id = p_inventory_item_id and
    organization_id = p_org_id;

Line: 1666

     SELECT count(inventory_item_id) into l_count FROM mtl_system_items_b
     WHERE organization_id = p_org_id AND inventory_item_id = p_activity_id
       AND eam_item_type = 2;

Line: 1689

   SELECT epa.next_service_start_date into l_date
     FROM eam_pm_schedulings eps, eam_pm_activities epa
    WHERE eps.maintenance_object_id = p_maintenance_object_id
      AND eps.maintenance_object_type = p_maintenance_object_type
      AND eps.default_implement = 'Y'
      AND eps.pm_schedule_id = epa.pm_schedule_id
      AND epa.activity_association_id = p_activity_association_id;

Line: 1713

   SELECT epa.next_service_end_date into l_date
     FROM eam_pm_schedulings eps, eam_pm_activities epa
    WHERE eps.maintenance_object_id = p_maintenance_object_id
      AND eps.maintenance_object_type = p_maintenance_object_type
      AND eps.default_implement = 'Y'
      AND eps.pm_schedule_id = epa.pm_schedule_id
      AND epa.activity_association_id = p_activity_association_id;