[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ID
FROM OKL_TRNS_ACC_DSTRS
WHERE aet_id = v_aet_id;
Okl_Acct_Event_Pub.delete_acct_event(p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_aetv_rec => p_aetv_rec);
Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs(p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_tabv_tbl => l_tabv_tbl,
x_tabv_tbl => x_tabv_tbl);
SELECT DISTINCT source_id,
source_table,
reverse_event_flag
FROM OKL_TRNS_ACC_DSTRS
WHERE posted_yn = 'S';
SELECT ID,
template_id,
TRUNC(gl_date) gl_date
FROM OKL_TRNS_ACC_DSTRS
WHERE source_id = v_source_id
AND source_table = v_source_table
AND reverse_event_flag = v_rev_flag;
SELECT tcn.trx_number,
try.trx_type_class
FROM OKL_TXL_CNTRCT_LNS tcl,
OKL_TRX_CONTRACTS tcn,
OKL_TRX_TYPES_V try
WHERE tcl.id = v_source_id
AND tcl.tcn_id = tcn.id
AND tcn.try_id = try.id;
SELECT tas.trans_number,
try.trx_type_class
FROM OKL_TXL_ASSETS_B tal,
OKL_TRX_ASSETS tas,
OKL_TRX_TYPES_V try
WHERE tal.id = v_source_id
AND tal.tas_id = tas.id
AND tas.try_id = try.id;
SELECT NVL(MAX(event_number),0)
FROM OKL_ACCOUNTING_EVENTS
WHERE source_id = v_source_id
AND source_table = v_source_table;
l_tabv_tbl.DELETE;
UPDATE OKL_TRNS_ACC_DSTRS
SET AET_ID =l_tabv_tbl(l_tab_count).AET_ID,
last_update_date = SYSDATE,
last_updated_by = Fnd_Global.user_id,
last_update_login = Fnd_Global.login_id,
program_update_date = SYSDATE,
program_application_id = Fnd_Global.prog_appl_id,
program_id = Fnd_Global.conc_program_id,
request_id = Fnd_Global.conc_request_id
WHERE ID = l_tabv_tbl(l_tab_count).ID;
Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs(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_tabv_tbl => l_tabv_tbl,
x_tabv_tbl => x_tabv_tbl);
SELECT ID
,CURRENCY_CONVERSION_TYPE
,CR_DR_FLAG
,CODE_COMBINATION_ID
,CURRENCY_CODE
,AE_LINE_TYPE
,TEMPLATE_ID
,SOURCE_ID
,SOURCE_TABLE
,AMOUNT
,ACCOUNTED_AMOUNT
,GL_DATE
,PERCENTAGE
,CURRENCY_CONVERSION_DATE
,CURRENCY_CONVERSION_RATE
FROM OKL_TRNS_ACC_DSTRS
WHERE aet_id = v_aet_id;
SELECT ae_header_id
FROM OKL_AE_HEADERS
WHERE accounting_event_id = v_aet_id;
SELECT
tcn.try_id
FROM
okl_txl_cntrct_lns txl,
okl_trx_contracts tcn
WHERE
txl.id = p_source_id AND
txl.tcn_id = tcn.id;
SELECT
tas.try_id
FROM
okl_txl_assets_b txl,
okl_trx_assets tas
WHERE
txl.id = p_source_id AND
txl.tas_id = tas.id;
SELECT ael.Accounted_Dr Accounted_Dr,
ael.Accounted_Cr Accounted_Cr
FROM OKL_AE_LINES AEL,
OKL_AE_HEADERS AEH
WHERE AEH.accounting_event_ID = v_event_id
AND AEL.ae_header_id = AEH.ae_header_id ;
SELECT ID
FROM OKL_TRNS_ACC_DSTRS
WHERE POSTED_YN = 'S';
SELECT accounting_event_id
FROM OKL_ACCOUNTING_EVENTS
WHERE event_status_code = 'CREATED';
Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs(
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_tabv_tbl => l_tabv_tbl,
x_tabv_tbl => x_tabv_tbl);
Okl_Acct_Event_Pub.delete_acct_event(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_aetv_tbl => l_aetv_tbl);
SELECT name
FROM hr_operating_units
WHERE organization_id = l_org_id;
SELECT COUNT(*) err_ae_headers
FROM okl_ae_headers ah
WHERE ah.request_id = p_request_id AND
ah.accounting_error_code IS NOT NULL;
SELECT COUNT(*) err_ae_lines
FROM okl_ae_lines ael
WHERE ael.request_id = p_request_id AND
ael.accounting_error_code IS NOT NULL;
SELECT ael.source_table source_table,
ael.source_id source_id,
ael.ae_line_number line_number,
aeh.accounting_date accounting_date,
DECODE(ael.accounted_cr,NULL,'DR','CR') dr_cr_flag,
DECODE(ael.accounted_dr,NULL,ael.accounted_cr, ael.accounted_dr) accounted_amount,
Okl_Accounting_Util.get_concat_segments(ael.code_combination_id) account,
ael.currency_code currency_code,
aeh.ae_category ae_category
FROM okl_ae_lines ael,
okl_ae_headers aeh,
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 ael.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 SUM(accounted_dr) total_dr,
SUM(accounted_cr) total_cr,
try.id try_id,
try.name try_name,
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.id,
try.name,
ael.currency_code
UNION
SELECT SUM(accounted_dr) total_dr,
SUM(accounted_cr) total_cr,
try.id try_id,
try.name try_name,
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.id,
try.name,
ael.currency_code;
SELECT
ael.source_table,
ael.source_id,
ael.ae_line_number,
aeh.accounting_date,
DECODE(ael.accounted_cr,NULL,'DR','CR') dr_cr_flag,
DECODE(ael.accounted_dr, NULL,ael.accounted_cr, ael.accounted_dr) accounted_amount,
Okl_Accounting_Util.get_concat_segments(ael.code_combination_id) account,
ael.currency_code,
aeh.ae_category
FROM
okl_ae_lines ael,
okl_ae_headers aeh
WHERE
ael.request_id = p_request_id AND
ael.currency_code = p_currency_code AND
ael.reference3 = p_try_id AND
ael.accounting_error_code IS NULL AND
ael.ae_header_id = aeh.ae_header_id AND
aeh.ae_category = p_category AND
aeh.accounting_error_code IS NULL
ORDER BY ael.source_id;
SELECT
SUM(accounted_dr) total_dr,
SUM(accounted_cr) total_cr,
try.id try_id,
try.name try_name,
aeh.ae_category ae_category,
ael.currency_code
FROM
okl_Ae_headers aeh,
okl_ae_lines ael,
okl_trx_types_v try
WHERE
aeh.request_id = p_request_id AND
aeh.accounting_error_code IS NULL AND
aeh.ae_header_id=ael.ae_header_id AND
ael.accounting_error_code IS NULL AND
ael.reference3 = try.id
GROUP BY aeh.ae_category, try.id, try.name, ael.currency_code;
SELECT
tcn.trx_number transaction_number,
try.name transaction_type,
khr.contract_number contract_number,
tcl.line_number transaction_line_number,
tcl.id source_id,
tcl.currency_code currency_code,
tcl.amount amount,
tcn.date_transaction_occurred transaction_date
FROM
okl_txl_cntrct_lns tcl,
okl_trx_contracts tcn,
okl_trx_types_v try,
okc_k_headers_b khr
WHERE
tcl.id = p_source_id AND
tcl.tcn_id = tcn.id AND
tcn.try_id = try.id AND
tcn.khr_id = khr.id
UNION ALL
SELECT
TO_CHAR(tas.trans_number) transaction_number,
try.name transaction_type,
khr.contract_number contract_number,
tal.line_number transaction_line_number,
tal.id source_id,
tal.currency_code currency_code,
tal.original_cost amount,
tas.date_trans_occurred transaction_date
FROM
okl_txl_assets_b tal,
okl_trx_assets tas,
okl_trx_types_v try,
okc_k_headers_b khr
WHERE
tal.id = p_source_id AND
tal.tas_id = tas.id AND
tas.try_id = try.id AND
tal.dnz_khr_id = khr.id;
SELECT
ael.source_table,
ael.source_id,
ael.ae_line_number,
aeh.accounting_date,
DECODE(ael.accounted_cr, NULL, 'DR', 'CR') dr_cr_flag,
DECODE(ael.accounted_dr, NULL, ael.accounted_cr, ael.accounted_dr) accounted_amount,
Okl_Accounting_Util.get_concat_segments(ael.code_combination_id) account,
ael.currency_code
FROM
okl_ae_lines ael,
okl_ae_headers aeh
WHERE
ael.request_id = l_request_id AND
ael.accounting_error_code = 'INVALID_ACCOUNT' AND
ael.ae_header_id = aeh.ae_header_id ORDER BY ael.source_id;
SELECT
ael.source_table source_table,
ael.source_id source_id,
ael.ae_line_number line_number,
aeh.accounting_date accounting_date,
DECODE(ael.accounted_cr, NULL, 'DR', 'CR') dr_cr_flag,
DECODE(ael.accounted_dr, NULL, ael.accounted_cr, ael.accounted_dr) accounted_amount,
Okl_Accounting_Util.get_concat_segments(ael.code_combination_id) account,
ael.currency_code currency_code
FROM
okl_ae_headers aeh,
okl_ae_lines ael
WHERE
aeh.request_id = l_request_id AND
aeh.accounting_error_code = 'DEBIT_NOT_EQUAL_TO_CREDIT' AND
aeh.ae_header_id = ael.ae_header_id ORDER BY ael.source_id;