[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT dhcc.code_combination_id,
FACB.CIP_COST_ACCT,
FACB.ASSET_COST_ACCT,
FADD.ASSET_NUMBER, FADD.DESCRIPTION,
fadd.tag_number, fadd.serial_number, fadd.inventorial,
FABKS.DATE_PLACED_IN_SERVICE,
FABKS.DEPRN_METHOD_CODE,
FABKS.LIFE_IN_MONTHS,
FABKS.PRODUCTION_CAPACITY,
FABKS.ADJUSTED_RATE,
ROUND(DECODE(FATRANS.TRANSACTION_TYPE_CODE,'CIP REVERSE',-1*(FABKS.COST),
FABKS.COST)*(SUM(FADH.UNITS_ASSIGNED)/FAHIST.UNITS),h_precision)
FROM GL_CODE_COMBINATIONS DHCC,
FA_DISTRIBUTION_HISTORY FADH,
FA_CATEGORY_BOOKS FACB,
FA_ASSET_HISTORY FAHIST,
FA_ADDITIONS FADD,
FA_BOOKS FABKS,
FA_TRANSACTION_HEADERS FATRANS
WHERE FATRANS.TRANSACTION_TYPE_CODE = 'ADDITION'
AND FATRANS.BOOK_TYPE_CODE = h_book
AND FATRANS.DATE_EFFECTIVE BETWEEN
h_period1_pod
AND nvl(h_period2_pcd, sysdate) -- fix for bug 2865813
AND EXISTS (SELECT NULL
FROM FA_ASSET_HISTORY AH
WHERE AH.ASSET_ID = FATRANS.ASSET_ID
AND AH.ASSET_TYPE = 'CIP')
AND FATRANS.ASSET_ID = FADH.ASSET_ID
AND FATRANS.BOOK_TYPE_CODE = FADH.BOOK_TYPE_CODE
AND FATRANS.DATE_EFFECTIVE >= FADH.DATE_EFFECTIVE
AND FATRANS.DATE_EFFECTIVE < NVL(FADH.DATE_INEFFECTIVE, SYSDATE)
AND FADH.CODE_COMBINATION_ID = DHCC.CODE_COMBINATION_ID
AND FATRANS.TRANSACTION_HEADER_ID = FABKS.TRANSACTION_HEADER_ID_IN
AND FABKS.ASSET_ID = FADD.ASSET_ID
AND FATRANS.TRANSACTION_HEADER_ID = FAHIST.TRANSACTION_HEADER_ID_IN
AND FATRANS.ASSET_ID = FAHIST.ASSET_ID
AND FAHIST.CATEGORY_ID = FACB.CATEGORY_ID
AND FACB.BOOK_TYPE_CODE = h_book
GROUP BY dhcc.code_combination_id,
FACB.CIP_COST_ACCT,
FACB.ASSET_COST_ACCT,
FADD.ASSET_NUMBER,
FADD.DESCRIPTION,
fadd.tag_number, fadd.serial_number, fadd.inventorial,
FABKS.DATE_PLACED_IN_SERVICE,
FABKS.DEPRN_METHOD_CODE,
FABKS.LIFE_IN_MONTHS,
FABKS.PRODUCTION_CAPACITY,
FABKS.ADJUSTED_RATE,
FATRANS.TRANSACTION_TYPE_CODE,
FABKS.COST,
FAHIST.UNITS,
FATRANS.ASSET_ID,
FABKS.DATE_EFFECTIVE;
select fcr.last_update_login into h_login_id
from fnd_concurrent_requests fcr
where fcr.request_id = h_request_id;
select period_open_date
into h_period1_pod
from fa_deprn_periods
where book_type_code = h_book and period_name = begin_period;
select count(*) into h_count
from fa_deprn_periods where period_name = end_period
and book_type_code = h_book;
select period_close_date
into h_period2_pcd
from fa_deprn_periods
where book_type_code = h_book and period_name = end_period;
select accounting_flex_structure
into h_acct_structure
from fa_book_controls
where book_type_code = h_book;
select cur.precision into h_precision
from fa_book_controls bc, gl_sets_of_books sob, fnd_currencies cur
where bc.book_type_code = h_book
and sob.set_of_books_id = bc.set_of_books_id
and sob.currency_code = cur.currency_code;
select decode(h_life_months, null, null,
to_char(floor(h_life_months/12)) || '.' ||
to_char(mod(h_life_months,12)))
into h_life_year_month
from dual;
h_mesg_name := 'FA_SHARED_INSERT_FAILED';
insert into fa_cap_rep_itf (
request_id, company, cost_center, expense_acct,
cip_cost_acct, asset_cost_acct, asset_number,
description, date_placed_in_service, method,
tag_number, serial_number, inventorial,
life_year_month, capacity, adjusted_rate, cost,
created_by, creation_date, last_updated_by,
last_update_date, last_update_login) values (
request_id, h_acct_segs(h_bal_seg), h_acct_segs(h_cc_seg),
h_acct_segs(h_acct_seg), h_cip_cost_acct,
h_asset_cost_acct, h_asset_number, h_description,
h_dpis, h_method, h_tag_number, h_serial_number, h_inventorial,
h_life_yr_mo_num, h_prod_capacity,
h_adjusted_rate, h_cost, user_id,
sysdate, user_id, sysdate, h_login_id);
if h_mesg_name = 'FA_SHARED_INSERT_FAIL' then
fnd_message.set_token('TABLE','FA_CAP_REP_ITF',FALSE);