APPS.OE_DEFAULT_SOURCE_TYPE_PVT SQL Statements

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

Line: 74

       	  		select 'Y' into item_in_org
       	  		from mtl_system_items
         		where inventory_item_id = p_item
         		and organization_id = l_warehouse;

Line: 84

    		select msi.purchasing_enabled_flag
    		into purchasable
    		from mtl_system_items msi
    		where msi.inventory_item_id = p_item
    		and msi.organization_id = FND_PROFILE.VALUE_SPECIFIC('SO_ORGANIZATION_ID');

Line: 97

    		select CA.action_id into
       		purchase_action
    		from
     		so_cycle_actions CA
     		where CA.action_id = PURCHASERELEASE
     		and CA.cycle_id = p_cycle_id
		and Nvl(CA.CHANGE_CODE,'ADDED') <> 'DELETED';

Line: 110

      		select CA.action_id into
          	pick_release_action
     		from
       		so_cycle_actions CA
       		where CA.action_id = PICKRELEASE
       		and CA.cycle_id = p_cycle_id
		and Nvl(CA.CHANGE_CODE,'ADDED') <> 'DELETED';