APPS.INV_TRANSACTION_LOVS SQL Statements

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

Line: 7

	SELECT reason_id,reason_name,description
	FROM MTL_TRANSACTION_REASONS
	WHERE NVL(DISABLE_DATE,SYSDATE) >= SYSDATE;

Line: 20

     select freight_code, description, distribution_account
     from
     org_enabled_freight_val_v
     where organization_id = (SELECT decode(FOB_POINT,1,TO_ORGANIZATION_ID,2, FROM_ORGANIZATION_ID) from mtl_interorg_parameters where TO_ORGANIZATION_ID = p_FromOrganization_Id and from_organization_id =p_ToOrganization_Id )
     AND freight_code LIKE p_carrier
     order by freight_code;

Line: 34

	   select transaction_type_id, transaction_type_name, description, transaction_action_id
	   from mtl_transaction_types
	   where transaction_source_type_id = p_transaction_Source_type_id;

Line: 46

        select transaction_type_id,transaction_type_name,description
	from mtl_transaction_types
	where transaction_action_id = p_Transaction_Action_Id and
	transaction_source_type_id = p_Transaction_Source_Type_Id and
	transaction_type_name like p_Transaction_Type_Name;

Line: 63

	select distribution_account,disposition_id,description from mtl_generic_dispositions
	where organization_id = p_Organization_Id and
	description like p_Description;

Line: 75

	SELECT a.code_combination_id,a.concatenated_segments FROM gl_code_combinations_kfv a,
	org_organization_definitions b
	WHERE b.organization_id = p_Organization_Id AND
	      a.chart_of_accounts_id = b.chart_of_accounts_id AND
	      a.concatenated_segments like p_Concatenated_Segments
	      and a.enabled_flag = 'Y' and nvl(a.start_date_active,sysdate-1)<=sysdate and
              nvl(a.end_date_active,sysdate+1)>sysdate;

Line: 89

	select concatenated_segments, inventory_item_id, description,
     revision_qty_control_code, lot_control_code, location_control_code,
     serial_number_control_code, restrict_subinventories_code,
     restrict_locators_code
	from mtl_system_items_kfv
	where organization_id = p_organization_id
	and mtl_transactions_enabled_flag = 'Y'
	and concatenated_segments like p_concatenated_segments;

Line: 112

	    select concatenated_segments,inventory_item_id,description,
	  revision_qty_control_code,lot_control_code,location_control_code,
	  serial_number_control_code,restrict_subinventories_code,
	  restrict_locators_code ,
	  Nvl(shelf_life_code, 1),
	  Nvl(shelf_life_days,0),
          Nvl(effectivity_control,1)
   	    from mtl_system_items_kfv
            where organization_id = p_Organization_Id
	    and mtl_transactions_enabled_flag = 'Y'
            and inventory_item_id IN
		(SELECT inventory_item_id
		 from mtl_system_items
		 where organization_id = p_To_Organization_Id
		 and mtl_transactions_enabled_flag = 'Y')
	    and concatenated_segments like p_Concatenated_Segments;

Line: 130

	    select concatenated_segments,inventory_item_id,description,
	   	   revision_qty_control_code,lot_control_code,
		   serial_number_control_code,restrict_subinventories_code,restrict_locators_code,
		   location_control_code,Nvl(shelf_life_code, 1),Nvl(shelf_life_days,0), Nvl(effectivity_control,1)
	    from mtl_system_items_kfv
	    where organization_id = p_Organization_Id
	    and mtl_transactions_enabled_flag = 'Y'
	    and concatenated_segments like p_Concatenated_Segments;

Line: 153

 	    select a.inventory_location_id, a.concatenated_segments,a.description
	    FROM mtl_item_locations_kfv a,mtl_secondary_locators b
	    WHERE b.organization_id = p_Organization_Id and
	          b.inventory_item_id = p_Inventory_Item_Id and
	      	  b.subinventory_code = p_Subinventory_Code and
	      	  a.inventory_location_id = b.secondary_locator and
	      	  a.concatenated_segments like (p_concatenated_segments);

Line: 162

	     select inventory_location_id,concatenated_segments,description
	     FROM mtl_item_locations_kfv
	     WHERE organization_id = p_Organization_Id and
	      	   subinventory_code = p_Subinventory_Code and
	           concatenated_segments like (p_concatenated_segments);

Line: 184

       select restrict_locators_code into l_Restrict_Locators_Code
       from mtl_system_items
       where inventory_item_id = p_Inventory_Item_Id and organization_id = l_org;

Line: 205

	SELECT secondary_inventory_name, description, locator_type, asset_inventory
   	FROM mtl_secondary_inventories
	WHERE organization_id = p_organization_id
	AND secondary_inventory_name like p_subinventory_code;

Line: 215

        SELECT secondary_inventory_name,description,asset_inventory
        FROM mtl_secondary_inventories
	WHERE 	organization_id = p_Organization_Id;

Line: 235

		 		SELECT secondary_inventory_name,description,asset_inventory
				FROM mtl_item_sub_trk_val_v
				WHERE 	organization_id = p_Organization_Id  AND
			      		inventory_item_id = p_Inventory_Item_Id AND
					secondary_inventory_name like p_Secondary_Inventory_Name;

Line: 243

		 		SELECT secondary_inventory_name,description,asset_inventory
				FROM mtl_subinventories_trk_val_v
		 		WHERE organization_Id = p_Organization_Id AND
		      		 secondary_inventory_name like p_Secondary_Inventory_Name;

Line: 251

				SELECT secondary_inventory_name,description,asset_inventory
				FROM mtl_item_sub_trk_val_v
				WHERE 	organization_id = p_Organization_Id  AND
			      		inventory_item_id = p_Inventory_Item_Id AND
					secondary_inventory_name like p_Secondary_Inventory_Name;

Line: 258

		 		SELECT secondary_inventory_name,description,asset_inventory
				FROM mtl_subinventories_trk_val_v
		 		WHERE organization_Id = p_Organization_Id AND
		      		 secondary_inventory_name like p_Secondary_Inventory_Name;

Line: 268

		 		SELECT secondary_inventory_name,description,asset_inventory
				FROM mtl_item_sub_val_v
				WHERE 	organization_id = p_Organization_Id  AND
			      		inventory_item_id = p_Inventory_Item_Id AND
					secondary_inventory_name like p_Secondary_Inventory_Name;

Line: 276

		 		SELECT secondary_inventory_name,description,asset_inventory
				FROM mtl_subinventories_trk_val_v
		 		WHERE organization_Id = p_Organization_Id AND
		      		 secondary_inventory_name like p_Secondary_Inventory_Name;

Line: 284

				SELECT secondary_inventory_name,description,asset_inventory
				FROM mtl_item_sub_trk_val_v
				WHERE 	organization_id = p_Organization_Id  AND
			      		inventory_item_id = p_Inventory_Item_Id AND
					secondary_inventory_name like p_Secondary_Inventory_Name;

Line: 291

		 		SELECT secondary_inventory_name,description,asset_inventory
				FROM mtl_subinventories_trk_val_v
		 		WHERE organization_Id = p_Organization_Id AND
		      		 secondary_inventory_name like p_Secondary_Inventory_Name;

Line: 306

        sELECT secondary_inventory_name,description,asset_inventory
        FROM mtl_secondary_inventories
	WHERE 	organization_id = p_Organization_Id
	AND secondary_inventory_name <> p_secondary_inventory_name;

Line: 333

	select restrict_subinventories_code
	into l_Restrict_Subinventories_Code
	from mtl_system_items
	where organization_id = l_org
	and inventory_item_id = p_Inventory_Item_Id;

Line: 346

	--select current_subinventory_code
	--into l_From_Sub
	--from mtl_serial_numbers
	--where current_organization_id = l_org
	--and serial_number = p_Serial
	--and inventory_item_id = p_Inventory_Item_Id;

Line: 353

	--select asset_inventory
	--into l_From_Sub_Asset_Inventory
	--from mtl_secondary_inventories
	--where organization_id = l_org
	--and secondary_inventory_name = l_From_Sub;

Line: 362

    SELECT Inventory_Asset_Flag
    INTO l_Inventory_Asset_Flag
    FROM mtl_system_items
    WHERE inventory_item_id = p_Inventory_Item_Id
    AND organization_id = l_org;

Line: 372

            	SELECT secondary_inventory_name,description
            	FROM MTL_ITEM_SUB_VAL_V
            	WHERE organization_id = l_org
              	AND inventory_item_id  = p_Inventory_Item_Id
              	AND secondary_inventory_name like p_Secondary_Inventory_Name;

Line: 379

            	SELECT secondary_inventory_name,description
	        FROM MTL_SUBINVENTORIES_VAL_V
            	WHERE ORGANIZATION_ID = l_org
              	AND SECONDARY_INVENTORY_NAME like p_Secondary_Inventory_Name;

Line: 389

				SELECT secondary_inventory_name,description
                   		FROM MTL_ITEM_SUB_VAL_V
                   		WHERE ORGANIZATION_ID = l_org
                    		AND INVENTORY_ITEM_ID = p_Inventory_Item_Id
                     		AND SECONDARY_INVENTORY_NAME like p_Secondary_Inventory_Name;

Line: 396

                   		SELECT secondary_inventory_name,description
                   		FROM MTL_ITEM_SUB_EXP_VAL_V
                   		WHERE ORGANIZATION_ID = l_org
                     		AND INVENTORY_ITEM_ID = p_Inventory_Item_Id
                     		AND SECONDARY_INVENTORY_NAME like p_Secondary_Inventory_Name;

Line: 404

               		SELECT secondary_inventory_name,description
               		FROM MTL_ITEM_SUB_VAL_V
               		WHERE ORGANIZATION_ID = l_org
                 	AND INVENTORY_ITEM_ID = p_Inventory_Item_Id
                 	AND SECONDARY_INVENTORY_NAME like p_Secondary_Inventory_Name;

Line: 414

                  SELECT secondary_inventory_name,description
                  FROM MTL_SUBINVENTORIES_VAL_V
                  WHERE ORGANIZATION_ID = l_org
                  AND SECONDARY_INVENTORY_NAME like p_Secondary_Inventory_Name;

Line: 420

                  SELECT secondary_inventory_name,description
                  FROM MTL_SUB_EXP_VAL_V
                  WHERE ORGANIZATION_ID = l_org
                  AND SECONDARY_INVENTORY_NAME like p_Secondary_Inventory_Name;

Line: 427

               SELECT secondary_inventory_name,description
               FROM MTL_SUBINVENTORIES_VAL_V
               WHERE ORGANIZATION_ID = l_org
               AND SECONDARY_INVENTORY_NAME like p_Secondary_Inventory_Name;

Line: 443

	select organization_code, organization_name, organization_id
	from org_access_view
	where responsibility_id = p_responsibility_id
	and p_resp_application_id = p_resp_application_id
	order by organization_code;

Line: 456

        SELECT
      a.to_organization_id,b.organization_code,c.name, a.intransit_type
      FROM mtl_interorg_parameters a, mtl_parameters b,hr_all_organization_units c
	WHERE a.from_organization_id = p_From_Organization_Id AND
      a.to_organization_id = b.organization_id
      AND a.to_organization_id = c.organization_id
      order by 2;

Line: 475

	 SELECT uom_Code, unit_of_measure, description FROM mtl_item_uoms_view
	 WHERE organization_id = p_Organization_Id AND
	       inventory_item_id = p_Inventory_Item_Id AND
 	       uom_Code like p_UOM_Code;

Line: 488

	 SELECT Lot_Number,to_char(expiration_date,'MM-DD-YYYY')
         FROM mtl_lot_numbers
	 WHERE organization_id = p_Organization_Id AND
	       inventory_item_id = p_Inventory_Item_Id AND
	       lot_number like (p_lot);

Line: 505

	 SELECT b.Lot_Number,to_char(b.expiration_date,'MM-DD-YYYY')
         FROM mtl_onhand_quantities_detail a, mtl_lot_numbers b
-- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ
	 WHERE a.organization_id = p_Organization_Id AND
     a.inventory_item_id = p_Inventory_Item_Id AND
     a.subinventory_code = p_subcode AND
     Nvl(a.revision, '##') = Nvl(p_revision,'##') AND
     Nvl(a.locator_id, '-1') = Nvl(p_locatorid ,'-1')AND
     a.lot_number = b.lot_number AND
     a.lot_number like (p_lot);

Line: 532

      SELECT revision, effectivity_date, Nvl(description,'')
      FROM mtl_item_revisions
      WHERE organization_Id = p_Organization_Id AND
	       inventory_item_id = p_Inventory_Item_Id AND
	       revision like (p_revision);

Line: 547

     	select serial_number,current_subinventory_code,current_locator_id, lot_number
 	from mtl_serial_numbers
	where Current_Organization_Id = p_Current_Organization_Id
	AND inventory_item_id = p_Inventory_Item_Id and current_status = 1
	and serial_number like p_Serial_Number;

Line: 565

	select serial_number,current_subinventory_code, current_locator_id,lot_number
	from mtl_serial_numbers
	where Current_Organization_Id = p_Current_Organization_Id
	and inventory_item_id = p_Inventory_Item_Id and current_status = 4
	and serial_number like p_serial_number;

Line: 573

	    select p_Serial_Number,p_Current_Subinventory_Code,p_Current_Locator_Id,
		   p_Lot_Number
	    from DUAL;

Line: 600

	    SELECT
	  a.serial_number,a.current_Subinventory_code,Nvl(a.current_locator_id,-1),
	  a.lot_number, a.revision ,b.expiration_date
 	    from mtl_serial_numbers a, mtl_lot_numbers b
	    where a.Current_organization_Id = p_Current_Organization_Id
	    and a.inventory_item_id = p_Inventory_Item_Id
	  and a.current_status = 3
	  AND a.lot_number = b.lot_number
	    and a.serial_number like p_serial_number;

Line: 612

					select a.serial_number,
					a.current_subinventory_code,
					Nvl(a.current_locator_id,-1),
					a.lot_number, a.revision,
					b.expiration_date
	    from mtl_serial_numbers a , mtl_lot_numbers b
	    where a.Current_organization_Id = p_Current_Organization_Id
	    and a.inventory_item_id = p_Inventory_Item_Id
            and a.current_status = 3
	    and a.serial_number like p_serial_number
	    and a.current_subinventory_code = p_current_subinventory_code
	 and Nvl(a.current_locator_id,-1) = Decode(p_current_locator_id,'-1',Nvl(a.current_locator_id,-1),p_current_locator_id)
	 AND a.lot_number = b.lot_number;