[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT tcn.trx_number,
khr.contract_number,
tcn.date_transaction_occurred,
tcl.line_number
FROM okl_trx_contracts tcn,
okl_trx_types_v try,
okc_k_headers_b khr,
okl_txl_cntrct_lns tcl
WHERE tcn.id = tcl.tcn_id AND
tcn.try_id = try.id AND
tcn.khr_id = khr.id AND
tcl.id = l_source_id;
SELECT tas.trans_number,
khr.contract_number,
tas.date_trans_occurred,
tal.line_number
FROM okl_trx_assets tas,
okl_txl_assets_b tal,
okl_trx_types_v try,
okc_k_headers_b khr
WHERE tas.id = tal.tas_id AND
tas.try_id = try.id AND
tal.dnz_khr_id = khr.id AND
tal.id = l_source_id;
SELECT sum(accounted_dr) total_dr,
sum(accounted_cr) total_cr,
try.name try_name,
try.id try_id,
aeh.ae_category ae_category,
ael.currency_code
FROM okl_Ae_headers aeh,
okl_ae_lines ael,
okl_trx_types_v try,
okl_txl_cntrct_lns tcl,
okl_trx_contracts tcn
WHERE aeh.ae_header_id=ael.ae_header_id
AND aeh.accounting_error_code IS NULL
AND ael.accounting_error_code IS NULL
AND aeh.request_id = p_request_id
AND ael.source_id = tcl.id
AND tcl.tcn_id = tcn.id
AND tcn.try_id = try.id
GROUP BY aeh.ae_category,
try.name,
try.id,
ael.currency_code
UNION
SELECT sum(accounted_dr) total_dr,
sum(accounted_cr) total_cr,
try.name try_name,
try.id try_id,
aeh.ae_category ae_category,
ael.currency_code
FROM okl_Ae_headers aeh,
okl_ae_lines ael,
okl_trx_types_v try,
okl_trx_assets tas,
okl_txl_assets_b tal
WHERE aeh.ae_header_id=ael.ae_header_id
AND aeh.accounting_error_code IS NULL
AND ael.accounting_error_code IS NULL
AND aeh.request_id = p_request_id
AND ael.source_id = tal.id
AND tal.tas_id = tas.id
AND tas.try_id = try.id
GROUP BY aeh.ae_category,
try.name,
try.id,
ael.currency_code;
SELECT ael.source_table,
ael.source_id,
ael.ae_line_number,
aeh.accounting_date,
aeh.ae_category,
ael.accounted_dr,
ael.accounted_cr,
okl_Accounting_util.get_concat_segments(ael.code_combination_id) account,
ael.currency_code
FROM okl_ae_headers aeh,
okl_ae_lines ael,
okl_txl_cntrct_lns tcl,
okl_trx_contracts tcn
WHERE ael.ae_header_id = aeh.ae_header_id
AND ael.gl_transfer_error_code is null
AND aeh.request_id = p_request_id
AND aeh.ae_category=p_category
AND ael.currency_code = p_currency_code
AND tcl.id = ael.source_id
AND tcl.tcn_id = tcn.id
AND tcn.try_id = p_try_id
ORDER BY ael.source_id;
SELECT ael.source_table,
ael.source_id,
ael.ae_line_number,
aeh.accounting_date,
aeh.ae_category,
ael.accounted_dr,
ael.accounted_cr,
okl_Accounting_util.get_concat_segments(ael.code_combination_id) account,
ael.currency_code
FROM okl_ae_headers aeh,
okl_ae_lines ael
WHERE ael.ae_header_id = aeh.ae_header_id
AND ael.gl_transfer_error_code is not null
AND aeh.request_id = p_request_id
ORDER BY ael.source_id;
SELECT count(*) total,
ael.gl_transfer_error_code
FROM okl_ae_headers aeh,
okl_ae_lines ael
WHERE aeh.request_id = p_request_id
AND aeh.ae_header_id = ael.ae_header_id
GROUP BY ael.gl_transfer_error_code;
SELECT name
FROM hr_operating_units
WHERE organization_id = p_org_id;