APPS.WSM_RESERVATIONS_GRP SQL Statements

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

Line: 92

	 SELECT WDJ.NET_QUANTITY,WDJ.PRIMARY_ITEM_ID
	 INTO x_available_quantity,l_item_id
	 FROM WIP_DISCRETE_JOBS WDJ
	 WHERE WDJ.WIP_ENTITY_ID = p_supply_demand_header_id;

Line: 98

	 select primary_uom_code
	 into x_source_primary_uom_code
	 from mtl_system_items
	 where inventory_item_id=l_item_id --p_item_id
	 and organization_id=p_organization_id;

Line: 187

	 	select
		wdj.scheduled_completion_date,
		wdj.net_quantity,
		wdj.status_type
		into
		l_scheduled_completion_date,
		l_net_qty,
		l_status_type
		from wip_entities we,
		wip_discrete_jobs wdj
		where wdj.wip_entity_id = p_supply_demand_header_id
		and we.wip_entity_id = wdj.wip_entity_id
		and wdj.job_type in (1,3)
		and we.entity_type = 5;

Line: 207

			 	l_msg_tokens.delete;

Line: 222

			 	l_msg_tokens.delete;

Line: 237

			 	l_msg_tokens.delete;