APPS.OKL_LIKE_KIND_EXCHANGE_PVT SQL Statements

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

Line: 11

	SELECT trx.req_asset_id, sum(trx.total_match_amount)
	FROM okl_trx_assets trx, okl_txl_assets_v txl, okl_txd_assets_v txd
    WHERE trx.id = txl.tas_id
	AND txl.id = txd.tal_id
	AND trx.total_match_amount IS NOT NULL
    AND txd.tax_book = p_tax_book_code
    AND trx.req_asset_id = p_req_asset_id
    GROUP BY trx.req_asset_id;

Line: 48

	SELECT proceeds_of_sale
	FROM OKL_LIKE_KIND_EXCHANGE_V
	WHERE asset_id = p_req_asset_id
	AND book_type_code = p_tax_book_code;

Line: 89

	SELECT proceeds_of_sale, gain_loss_amount
	FROM OKL_LIKE_KIND_EXCHANGE_V
	WHERE asset_id = p_req_asset_id
	AND book_type_code = p_tax_book_code;

Line: 127

    SELECT location_id
    FROM   okx_ast_dst_hst_v
    WHERE  asset_id = p_asset_id
    AND    book_type_code = p_book_type_code
    AND    status = 'A'
    AND    nvl(start_date_active,sysdate) <= sysdate
    AND    nvl(end_date_active,sysdate+1) > sysdate
    AND    transaction_header_id_out is null
    AND    retirement_id is null
    AND    rownum < 2;

Line: 238

   l_trans_rec.who_info.last_updated_by := FND_GLOBAL.USER_ID;

Line: 303

     SELECT deprn_reserve*p_split_factor,
            deprn_reserve*p_split_factor,
            reval_deprn_expense*p_split_factor
     INTO   l_asset_deprn_rec.ytd_deprn,
            l_asset_deprn_rec.deprn_reserve,
            l_asset_deprn_rec.reval_deprn_reserve
     FROM   okx_ast_dprtns_v
     WHERE  asset_id = p_asdt_rec.asset_id
     AND    book_type_code = p_asdt_rec.book_type_code
     AND    deprn_run_date = (SELECT max(deprn_run_date)
                              FROM   okx_ast_dprtns_v
                              WHERE  asset_id = p_asdt_rec.asset_id
                              AND    book_type_code = p_asdt_rec.book_type_code);

Line: 321

   select p_txdv_rec.quantity,
          assigned_to,
          code_combination_id,
          location_id
   into   l_asset_dist_rec.units_assigned,
          l_asset_dist_rec.assigned_to,
          l_asset_dist_rec.expense_ccid,
          l_asset_dist_rec.location_ccid
   from   okx_ast_dst_hst_v
   where  asset_id = p_asdt_rec.asset_id
   and    book_type_code = p_txlv_rec.corporate_book
   and    transaction_header_id_out is null
   and    retirement_id is not null
   and    rownum < 2;

Line: 577

  SELECT id
  FROM OKL_TRX_TYPES_TL
  WHERE NAME = l_try_name
  AND LANGUAGE = 'US';

Line: 585

  SELECT *
  FROM OKL_LIKE_KIND_EXCHANGE_V
  WHERE ASSET_ID = p_asset_id
  AND BOOK_TYPE_CODE = p_book_type_code;

Line: 593

  SELECT *
  FROM OKL_LIKE_KIND_EXCHANGE_V
  WHERE ASSET_ID = p_asset_id
  AND BOOK_TYPE_CODE = p_book_type_code;

Line: 601

  SELECT 'F'
  FROM   OKX_AST_CAT_BKS_V
  WHERE  CATEGORY_ID = p_category_id
  AND    BOOK_TYPE_CODE = p_book_type_code
  AND    STATUS = 'A';

Line: 610

  SELECT 'F'
  FROM   OKX_AST_BKS_V
  WHERE  asset_id = p_asset_id
  AND    book_type_code = p_book_type_code
  AND    status = 'A';

Line: 619

  SELECT 'F'
  FROM   OKX_ASST_BK_CONTROLS_V
  WHERE  book_type_code = p_tax_book
  AND    book_class = 'TAX'
  AND    mass_copy_source_book = p_corp_book
  AND    allow_mass_copy = 'YES'
  AND    copy_additions_flag = 'YES';

Line: 630

  SELECT CHR.CONTRACT_NUMBER
  FROM OKC_K_HEADERS_B CHR,
       OKC_K_LINES_B CLE
  WHERE CLE.DNZ_CHR_ID = CHR.ID
  AND CLE.ID = p_kle_id;

Line: 733

	    l_req_asset_tbl.DELETE(i);

Line: 884

    SELECT 'OKL'||OKL_FAN_SEQ.NEXTVAL INTO l_talv_rec.asset_number FROM DUAL;

Line: 1063

    OKL_TXL_ASSETS_PUB.update_txl_asset_Def(
                       p_api_version    => p_api_version,
                       p_init_msg_list  => p_init_msg_list,
                       x_return_status  => l_return_status,
                       x_msg_count      => x_msg_count,
                       x_msg_data       => x_msg_data,
                       p_tlpv_rec       => l_talv_rec,
                       x_tlpv_rec       => x_talv_rec);