APPS.INVIDTMP_PKG SQL Statements

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

Line: 38

	select t.attribute_name,
	       t.attribute_value
	from mtl_item_templ_attributes t
	where template_id = X_template_id;

Line: 52

	Select inventory_item_status_code_tl
	INTO X_inventory_item_status_code
	from mtl_item_status
	where  nvl(disable_date, sysdate+1) > sysdate
	and inventory_item_status_code = v_attr_value;

Line: 64

	SELECT unit_of_measure_tl
        INTO   X_primary_unit_of_measure
        FROM   mtl_units_of_measure_vl
        WHERE  uom_code = v_attr_value;

Line: 151

  select meaning
  into v_meaning
  from mfg_lookups
  where lookup_type = X_lu_type
  and lookup_code = X_lu_code;

Line: 171

  select meaning
  into v_meaning
  from fnd_common_lookups
  where lookup_type = X_lu_type
  and lookup_code = X_lu_code;