[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT pa.project_asset_id,
pa.asset_number
FROM pa_project_assets pa
WHERE pa.project_asset_type = 'AS-BUILT'
AND pa.capitalized_flag = 'Y'
AND pa.fa_period_name IS NULL;
SELECT fdp.period_name, MIN(fit.date_effective)
FROM fa_deprn_periods fdp,
fa_asset_invoices fai,
fa_invoice_transactions fit,
pa_project_asset_lines_all pal
WHERE fai.project_asset_line_id = pal.project_asset_line_id
AND pal.project_asset_id = x_project_asset_id
AND fai.invoice_transaction_id_in = fit.invoice_transaction_id
AND fit.transaction_type = 'MASS ADDITION'
AND fit.book_type_code = fdp.book_type_code
AND fit.date_effective BETWEEN fdp.period_open_date
AND NVL(fdp.period_close_date,fit.date_effective)
GROUP BY fdp.period_name
ORDER BY MIN(fit.date_effective);
SELECT pal.project_asset_line_id,
pal.current_asset_cost
FROM pa_project_assets pa,
pa_project_asset_lines_all pal
WHERE pa.project_asset_id = pal.project_asset_id
AND pa.project_asset_type = 'AS-BUILT'
AND pal.transfer_status_code = 'T'
AND pal.line_type = 'C'
AND pal.fa_period_name IS NULL;
SELECT fdp.period_name,
SUM(payables_cost) payables_cost
FROM fa_deprn_periods fdp,
fa_asset_invoices fai,
fa_invoice_transactions fit
WHERE fai.project_asset_line_id = x_project_asset_line_id
AND fai.invoice_transaction_id_in = fit.invoice_transaction_id
AND fit.transaction_type = 'MASS ADDITION'
AND fit.book_type_code = fdp.book_type_code
AND fit.date_effective BETWEEN fdp.period_open_date
AND NVL(fdp.period_close_date,fit.date_effective)
GROUP BY fdp.period_name;
SELECT fa.asset_id, fa.asset_number
FROM fa_additions fa,
fa_asset_invoices fai,
pa_project_asset_lines_all pal
WHERE fai.project_asset_line_id = pal.project_asset_line_id
AND pal.project_asset_id = x_project_asset_id
AND fai.asset_id = fa.asset_id
GROUP BY fa.asset_id, fa.asset_number;
UPDATE pa_project_assets_all
SET asset_number = v_asset_number,
fa_asset_id = v_asset_id,
fa_period_name = v_fa_period_name,
last_update_date = SYSDATE,
last_updated_by = v_user,
last_update_login = v_login,
request_id = v_request_id,
program_application_id = v_program_application_id,
program_id = v_program_id
WHERE project_asset_id = project_assets_rec.project_asset_id;
UPDATE pa_project_assets_all
SET fa_period_name = v_fa_period_name,
fa_asset_id = v_asset_id,
last_update_date = SYSDATE,
last_updated_by = v_user,
last_update_login = v_login,
request_id = v_request_id,
program_application_id = v_program_application_id,
program_id = v_program_id
WHERE project_asset_id = project_assets_rec.project_asset_id;
UPDATE pa_project_asset_lines_all
SET fa_period_name = asset_line_period_rec.period_name,
last_update_date = SYSDATE,
last_updated_by = v_user,
last_update_login = v_login,
request_id = v_request_id,
program_application_id = v_program_application_id,
program_id = v_program_id
WHERE project_asset_line_id = asset_lines_rec.project_asset_line_id;