[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT h.khr_id
FROM okl_k_headers h
WHERE h.id = cp_chr_id;
SELECT h.authoring_org_id
FROM okc_k_headers_b h
WHERE h.id = cp_chr_id;
SELECT h.currency_code
FROM okc_k_headers_b h
WHERE h.id = cp_chr_id;
SELECT cim.number_of_items asset_quantity
FROM okc_k_lines_b cle,
okc_line_styles_b lse,
okc_k_items cim
WHERE cle.cle_id = cp_cle_id
AND lse.id = cle.lse_id
AND lse.lty_code = 'ITEM'
AND cim.cle_id = cle.id;
SELECT c.minimum_accountable_unit, c.precision
FROM fnd_currencies c
WHERE c.currency_code = cp_currency_code;
SELECT attribute_label_long
FROM ak_attributes_vl attr
WHERE attr.attribute_application_id = 540
AND attr.attribute_code = cp_code;
SELECT count (*)
FROM okl_trx_msgs m
WHERE m.trx_source_table = cp_trx_table
AND m.trx_id = cp_trx_id;
SELECT sum (nvl (l.amount,0))
FROM okl_txl_qte_lines_all_b l
WHERE l.qte_id = cp_quote_id
AND l.qlt_code <> 'AMCTAX'; -- rmunjulu sales_tax_enhancement exclude tax line as tax is coming from tax entities
SELECT *
FROM fnd_lookups fndlup
WHERE fndlup.lookup_type = cp_lookup_type
AND fndlup.lookup_code = cp_lookup_code;
SELECT o.description
FROM okl_formulae_v f,
okl_fmla_oprnds_v fo,
okl_operands_v o
WHERE f.name = cp_formula_name
AND f.start_date <= SYSDATE
AND NVL (f.end_date, SYSDATE) >= SYSDATE
AND fo.fma_id = f.id
AND fo.label = cp_operand_name
AND o.id = fo.opd_id;
SELECT rd.meaning
FROM okc_rule_defs_v rd
WHERE rd.application_id = 540
AND rd.rule_code = cp_rule_code;
SELECT id
FROM okl_trx_types_tl t
WHERE Upper (t.name) LIKE Upper (cp_try_name)
AND t.language = Upper (cp_language);
SELECT id
FROM okl_strm_type_b s
WHERE s.code = cp_sty_code;
SELECT rd.meaning
FROM okc_rule_defs_v rd
WHERE rd.application_id = 540
AND rd.rule_code = cp_rule_code;
SELECT scs_code
FROM okc_k_headers_b
WHERE id = p_chr_id;
SELECT CHR.bill_to_site_use_id, -- RMUNJULU 3394507 get bill to site id from K Header
CPL.ROLE party_role,
CPL.jtot_object1_code jtot_object1_code,
CPL.object1_id1 object1_id1,
CPL.object1_id2 object1_id2
FROM OKC_K_HEADERS_B CHR,
OKC_K_PARTY_ROLES_V CPL
WHERE CHR.id = p_chr_id
AND CHR.id = CPL.chr_id
AND CPL.rle_code = 'LESSEE';
-- Select bill_to record
CURSOR l_bill_to_address_csr (cp_id1 NUMBER) IS
SELECT *
FROM okx_cust_site_uses_v cst
WHERE cst.id1 = cp_id1;
SELECT f.formula_string
FROM okl_formulae_v f
WHERE f.name = cp_formula_name
AND f.start_date <= SYSDATE
AND NVL (f.end_date, sysdate) >= SYSDATE;
OKL_TRX_MSGS_PUB.insert_trx_msgs (
p_api_version => l_api_version,
p_init_msg_list => OKL_API.G_FALSE,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_tmgv_tbl => lp_tmgv_tbl,
x_tmgv_tbl => lx_tmgv_tbl);
p_other_select IN select_tbl_type,
p_other_where IN where_tbl_type,
x_object_tbl OUT NOCOPY jtf_object_tbl_type,
x_return_status OUT NOCOPY VARCHAR2) IS
l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
SELECT ob.from_table,
ob.where_clause
FROM jtf_objects_b ob
WHERE ob.object_code = cp_object_code;
'SELECT ''' || p_object_code || ''', ' ||
p_object_code || '.ID1, ' ||
p_object_code || '.ID2, ' ||
p_object_code || '.NAME, ' ||
p_object_code || '.DESCRIPTION, ' ;
IF p_other_select.COUNT > 0 THEN
FOR l_ind IN p_other_select.FIRST..p_other_select.LAST LOOP
l_query_string := l_query_string ||
' REPLACE ( ' ||
p_object_code || '.' || p_other_select (l_ind) ||
', ''' || G_DELIM || ''',''' || G_DELIM || G_DELIM || ''') ' ||
'|| ''' || G_DELIM || ''' ||';
l_other_cols select_tbl_type;
p_other_select => l_other_cols,
x_object_tbl => l_object_tbl,
x_return_status => l_return_status);
SELECT rdf.object1_id1,
rdf.object2_id1,
rdf.object3_id1,
rdf.object1_id2,
rdf.object2_id2,
rdf.object3_id2,
rdf.jtot_object1_code,
rdf.jtot_object2_code,
rdf.jtot_object3_code
FROM okc_rule_groups_b rgp,
okc_rules_b rdf
WHERE rgp.chr_id = cp_chr_id
AND rgp.cle_id = cp_cle_id
AND (cp_chr_id= -9999 or rgp.dnz_chr_id = cp_dnz_chr_id)
AND rgp.rgd_code = cp_rgd_code
AND rdf.rgp_id = rgp.id
AND rdf.rule_information_category = cp_rdf_code;
SELECT kpr.jtot_object1_code,
kpr.object1_id1,
kpr.object1_id2
FROM okl_k_headers khr,
okc_k_headers_b par,
okc_k_party_roles_b kpr
WHERE khr.id = cp_chr_id
AND par.id = khr.khr_id
AND par.scs_code = 'PROGRAM'
AND kpr.chr_id = par.id
AND kpr.rle_code = 'OKL_VENDOR'
AND kpr.object1_id1 IS NOT NULL;
SELECT opt.jtf_amv_item_id, opt.email_subject_line
FROM OKL_CS_PROCESS_TMPLTS_UV opt
WHERE opt.ptm_code = c_ptm_code
AND opt.start_date < sysdate
AND nvl(opt.end_date, sysdate+1) > sysdate;
SELECT nvl(ppf.email_address , fu.email_address) email
FROM fnd_user fu,
per_people_f ppf
WHERE fu.employee_id = ppf.person_id (+)
AND fu.user_id = c_agent_id;
SELECT server.server_name server_name
FROM jtf_fm_group_fnd_user_v users
, jtf_fm_group groups
, jtf_fm_service server
WHERE users.user_id = c_agent_id
AND users.group_id = groups.group_id
AND server.server_id = groups.server_id
AND server.server_id = c_server_id;
SELECT server.server_name server_name
FROM jtf_fm_service server
WHERE server.server_id = c_server_id;
cursor av_csr is select table_name,Column_Name ,data_type,data_length,NVL(data_precision,OKC_API.G_MISS_NUM)
data_precision,NVL(data_scale,0) data_scale
FROM user_tab_columns
WHERE table_name = UPPER( p_view_name) and (data_type='VARCHAR2' OR data_type='NUMBER');
cursor c1 is select value from v$nls_parameters where parameter='NLS_NUMERIC_CHARACTERS';
SELECT WFEV.display_name
FROM WF_EVENTS_VL WFEV,
WF_EVENT_SUBSCRIPTIONS WFES
WHERE WFEV.guid = WFES.event_filter_guid
AND WFES.wf_process_type = p_process_type
AND UPPER(WFES.wf_process_name) = UPPER(p_process_name);
SELECT QTE.id id,
QTE.quote_number quote_number,
KHR.contract_number contract_number,
QTE.partial_yn partial_yn,
QTE.qst_code qst_code,
QTE.qtp_code qtp_code
FROM OKL_TRX_QUOTES_V QTE,
OKC_K_HEADERS_V KHR
WHERE QTE.khr_id = KHR.id
AND NVL(QTE.accepted_yn,'N') = 'Y'
AND NVL(QTE.consolidated_yn,'N') = 'N' -- non consolidated
AND QTE.khr_id = p_khr_id;
SELECT QTE.id id,
QTE.quote_number quote_number,
KHR.contract_number contract_number,
QTE.partial_yn partial_yn,
QTE.qst_code qst_code,
QTE.qtp_code qtp_code
FROM OKL_TRX_QUOTES_V QTE,
OKL_TXL_QUOTE_LINES_V TQL,
OKC_K_LINES_V KLE,
OKC_K_HEADERS_V KHR
WHERE TQL.kle_id = KLE.id
AND TQL.qte_id = QTE.id
AND KLE.chr_id = KHR.id
AND TQL.qlt_code = 'AMCFIA'
AND NVL(QTE.accepted_yn,'N') = 'Y'
AND NVL(QTE.consolidated_yn,'N') = 'N' -- non consolidated
AND TQL.kle_id = p_kle_id;
select tcn.id id,
tcn.trx_number trx_number,
tcn.tmt_status_code tsu_code, --akrangan changed tsu_code to tmt_status_code
tcn.tcn_type tcn_type,
khr.contract_number contract_number,
qteb.quote_number quote_number,
qteb.partial_yn partial_yn,
qteb.qst_code qst_code,
qteb.qtp_code qtp_code
from okl_trx_contracts tcn,
okl_trx_quotes_all_b qteb,
okl_trx_quotes_tl qte,
okc_k_headers_all_b khr
where tcn.khr_id = khr.id
and tcn.qte_id = qteb.id(+)
and qteb.id = qte.id(+)
and qte.language(+) = userenv('LANG')
and tcn.tcn_type in ('TMT','ALT','EVG')-- akrangan bug 5354501 fix added 'EVG'
and tcn.tmt_status_code not in ('CANCELED','PROCESSED') --akrangan changed
--tsu_code to tmt_status code
and tcn.khr_id = p_khr_id
--rkuttiya added for 12.1.1 multi gaap project
and tcn.representation_type = 'PRIMARY';
SELECT TCN.id id,
TCN.trx_number trx_number,
TCN.tmt_status_code tsu_code, --akrangan changed tsu_code to tmt_status_code
TCN.tcn_type tcn_type,
QTE.quote_number quote_number,
QTE.partial_yn partial_yn,
QTE.qst_code qst_code,
QTE.qtp_code qtp_code
FROM OKL_TRX_CONTRACTS TCN,
OKL_TRX_QUOTES_B QTE,
OKL_TXL_QUOTE_LINES_B TQL
WHERE TCN.qte_id = QTE.id
AND TQL.qte_id = QTE.id
AND TCN.tcn_type IN ('TMT','ALT' , 'EVG')-- akrangan bug 5354501 fix added 'EVG'
--rkuttiya added for 12.1.1 multi gaap project
AND TCN.representation_type = 'PRIMARY'
--
AND TQL.qlt_code = 'AMCFIA'
AND TCN.tmt_status_code NOT IN ( 'PROCESSED','CANCELED') --akrangan changed tsu_code to tmt_status_code
AND TQL.kle_id = p_kle_id;
SELECT QTE.id id,
QTE.quote_number quote_number,
KHR.contract_number contract_number,
QTE.partial_yn partial_yn,
QTE.qst_code qst_code,
QTE.qtp_code qtp_code
FROM OKL_TRX_QUOTES_V QTE,
OKC_K_HEADERS_V KHR
WHERE QTE.khr_id = KHR.id
AND NVL(QTE.accepted_yn,'N') = 'Y'
AND QTE.qtp_code LIKE 'TER%' -- ansethur 07-aug-2007 Added for bug 5932098
AND NVL(QTE.consolidated_yn,'N') = 'N' -- non consolidated
AND QTE.khr_id = p_khr_id;
SELECT TRX.id id
FROM OKL_TRX_CONTRACTS TRX
WHERE TRX.tcn_type IN ('TMT','ALT' , 'EVG')-- akrangan bug 5354501 fix added 'EVG'
--rkuttiya added for 12.1.1 multi gaap
AND TRX.representation_type = 'PRIMARY'
--
AND TRX.qte_id = p_qte_id;
SELECT gl.currency_code
FROM GL_LEDGERS_PUBLIC_V gl, HR_ALL_ORGANIZATION_UNITS O, HR_ORGANIZATION_INFORMATION O3
WHERE gl.ledger_id = O3.ORG_INFORMATION3
AND o.organization_id = p_org_id
AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID
AND O3.ORG_INFORMATION_CONTEXT = 'Operating Unit Information';
SELECT user_profile_option_name
FROM fnd_profile_options_vl
WHERE profile_option_name = p_profile_option_name;
SELECT QTE.id id,
QTE.quote_number quote_number,
KHR.contract_number contract_number,
QTE.partial_yn partial_yn,
QTE.consolidated_yn consolidated_yn,
QTE.qst_code qst_code,
QTE.qtp_code qtp_code
FROM OKL_TRX_QUOTES_B QTE,
OKL_TXL_QTE_LINES_ALL_B TQL,
OKC_K_LINES_B KLE,
OKC_K_HEADERS_ALL_B KHR
WHERE TQL.kle_id = KLE.id
AND TQL.qte_id = QTE.id
AND KLE.chr_id = KHR.id
AND TQL.qlt_code = 'AMCFIA'
AND QTE.qtp_code LIKE 'TER%'
AND TQL.kle_id = p_kle_id;
SELECT chr.sts_code,khr.deal_type
FROM okl_k_headers khr, okc_k_headers_b chr
WHERE khr.id = p_khr_id
AND KHR.ID = CHR.ID;
SELECT deal_type
FROM okl_k_headers
WHERE id = p_khr_id;
SELECT date_effective_from
FROM OKL_TRX_QUOTES_B
WHERE id = p_quote_id;
SELECT object1_id1,
object1_id2,
jtot_object1_code
FROM okc_k_party_roles_b
WHERE dnz_chr_id = p_chr_id
AND rle_code = p_rle_code
AND nvl(cle_id,1) = nvl(p_Kle_id,nvl(cle_id,1));
SELECT QTE.id id,
QTE.quote_number quote_number,
KHR.contract_number contract_number,
QTE.partial_yn partial_yn,
QTE.consolidated_yn consolidated_yn,
QTE.qst_code qst_code,
QTE.qtp_code qtp_code
FROM OKL_TRX_QUOTES_B QTE,
OKC_K_HEADERS_B KHR
WHERE qte.khr_id = khr.id
AND qte.khr_id = p_khr_id
AND QTE.qtp_code LIKE 'TER%';
SELECT kle.date_terminated
FROM OKC_K_LINES_B kle
WHERE kle.id = p_kle_id;
SELECT qte.id,
qte.qtp_code, -- quote type
qte.date_accepted, -- quote acceptance date
nvl(tql.asset_value,0) net_investment -- rmunjulu 4399736
FROM OKL_TRX_CONTRACTS trn,
OKL_TRX_QUOTES_B qte,
OKL_TXL_QUOTE_LINES_B tql
WHERE trn.khr_id = p_khr_id
AND trn.tmt_status_code <> 'CANCELED' --akrangan changed tsu_code to tmt_status_code
AND trn.qte_id = qte.id
--rkuttiya added for 12.1.1 Multi GAAAP Project
AND trn.representation_type = 'PRIMARY'
--
AND qte.id = tql.qte_id
AND tql.qlt_code = 'AMCFIA'
AND tql.kle_id = p_kle_id;
SELECT tql.amount
FROM OKL_TXL_QUOTE_LINES_B tql
WHERE tql.qte_id = p_qte_id
AND tql.kle_id = p_kle_id
AND tql.qlt_code = 'AMBPOC';
SELECT khr.deal_type
FROM OKL_K_HEADERS khr
WHERE khr.id = p_khr_id;
SELECT fds.deprn_reserve deprn_amt
FROM fa_deprn_summary fds,
fa_deprn_periods fdp,
fa_book_controls fbc,
fa_calendar_periods fcp,
okc_k_items_v itm,
okc_k_lines_b kle,
okc_line_styles_v lse
WHERE fdp.book_type_code = fds.book_type_code
AND fdp.period_counter = fds.period_counter
AND fbc.book_class = 'CORPORATE'
AND fds.book_type_code = fbc.book_type_code
AND fds.asset_id = itm.object1_id1
AND itm.cle_id = kle.id
AND kle.cle_id = p_kle_id
AND kle.lse_id = lse.id
AND lse.lty_code = 'FIXED_ASSET'
AND fbc.deprn_calendar = fcp.calendar_type
AND fcp.period_name = fdp.period_name
AND TRUNC(p_ter_date) BETWEEN fcp.START_DATE AND fcp.end_date;
select fds.deprn_reserve deprn_amt
from fa_deprn_summary fds,
fa_deprn_periods fdp,
fa_book_controls fbc,
okc_k_items itm,
okc_k_lines_b kle,
okc_line_styles_b lse
where fdp.book_type_code = fds.book_type_code
and fdp.period_counter - 1 = fds.period_counter
and fdp.period_close_date is null
and fbc.book_class = 'CORPORATE'
and fds.book_type_code = fbc.book_type_code
and fds.asset_id = itm.object1_id1
and itm.cle_id = kle.id
and kle.cle_id = p_kle_id
and kle.lse_id = lse.id
and lse.lty_code = 'FIXED_ASSET';
SELECT fab.original_cost
FROM fa_books fab,
fa_book_controls fbc,
okc_k_items_v itm,
okc_k_lines_b kle,
okc_line_styles_v lse
WHERE fbc.book_class = 'CORPORATE'
AND fab.book_type_code = fbc.book_type_code
AND fab.asset_id = itm.object1_id1
AND itm.cle_id = kle.id
AND kle.cle_id = p_kle_id
AND kle.lse_id = lse.id
AND lse.lty_code = 'FIXED_ASSET'
AND fab.transaction_header_id_out IS NULL;
SELECT depreciation_cost
FROM okl_txl_assets_b
WHERE kle_id = p_kle_id
AND tal_type = 'AML'
AND ROWNUM < 2;
SELECT nvl(residual_value,0) residual_value
FROM okl_k_lines
WHERE id = p_kle_id;
SELECT a.COST cost
FROM okx_asset_lines_v o, fa_books a, fa_book_controls b
WHERE o.parent_line_id = p_kle_id
AND o.asset_id = a.asset_id
AND a.book_type_code = b.book_type_code
AND a.date_ineffective IS NULL
AND a.transaction_header_id_out IS NULL
AND b.book_class = 'CORPORATE';
SELECT nvl(sum(tqa.amount),0) amount
FROM okl_txd_qte_antcpt_bill tqa
WHERE tqa.qte_id = p_qte_id;
SELECT nvl(fds.deprn_reserve,0) deprn_amt
FROM fa_deprn_summary fds,
fa_deprn_periods fdp,
fa_book_controls fbc,
fa_calendar_periods fcp,
okc_k_items_v itm,
okc_k_lines_b kle,
okc_line_styles_v lse
WHERE fdp.book_type_code = fds.book_type_code
AND fdp.period_counter = fds.period_counter
AND fbc.book_class = 'CORPORATE'
AND fds.book_type_code = fbc.book_type_code
AND fds.asset_id = itm.object1_id1
AND itm.cle_id = kle.id
AND kle.cle_id = p_kle_id
AND kle.lse_id = lse.id
AND lse.lty_code = 'FIXED_ASSET'
AND fbc.deprn_calendar = fcp.calendar_type
AND fcp.period_name = fdp.period_name
AND TRUNC(p_trn_date) BETWEEN fcp.start_date AND fcp.end_date;
SELECT nvl(fds.deprn_reserve,0) deprn_amt
FROM fa_deprn_summary fds,
fa_deprn_periods fdp,
fa_book_controls fbc,
okc_k_items itm,
okc_k_lines_b kle,
okc_line_styles_b lse
WHERE fdp.book_type_code = fds.book_type_code
AND fdp.period_counter - 1 = fds.period_counter
AND fdp.period_close_date IS NULL
AND fbc.book_class = 'CORPORATE'
AND fds.book_type_code = fbc.book_type_code
AND fds.asset_id = itm.object1_id1
AND itm.cle_id = kle.id
AND kle.cle_id = p_kle_id
AND kle.lse_id = lse.id
AND lse.lty_code = 'FIXED_ASSET';
SELECT nvl(fab.cost,0) current_cost
FROM fa_books fab,
fa_book_controls fbc,
okc_k_items_v itm,
okc_k_lines_b kle,
okc_line_styles_v lse
WHERE fbc.book_class = 'CORPORATE'
AND fab.book_type_code = fbc.book_type_code
AND fab.asset_id = itm.object1_id1
AND itm.cle_id = kle.id
AND kle.cle_id = p_kle_id
AND kle.lse_id = lse.id
AND lse.lty_code = 'FIXED_ASSET'
AND fab.transaction_header_id_out IS NULL;
SELECT SUM(TAX.tax_amt) tax_amount
FROM OKL_TAX_SOURCES TXS,
OKL_TAX_TRX_DETAILS TAX
WHERE TXS.trx_id = p_tax_trx_id
AND TAX.txs_id = TXS.id;
SELECT PQY.NAME QUALITY,
QVE.VALUE VALUE,
KHR.DEAL_TYPE DEAL_TYPE
FROM OKL_PDT_PQY_VALS PQV ,
OKL_PDT_PQYS PDQ ,
OKL_PRODUCTS PDT,
OKL_PQY_VALUES QVE,
OKL_PDT_QUALITYS PQY,
OKL_K_HEADERS KHR
WHERE KHR.ID = p_khr_id
AND PQV.PDT_ID = PDT.ID
AND PQV.PDQ_ID = PDQ.ID
AND PQV.QVE_ID = QVE.ID
AND QVE.PQY_ID = PQY.ID
AND PDQ.PQY_ID = PQY.ID
AND PDT.PTL_ID = PDQ.PTL_ID
AND PDT.ID = KHR.PDT_ID
AND PQY.NAME IN ( 'INTEREST_CALCULATION_BASIS', 'REVENUE_RECOGNITION_METHOD', 'TAXOWNER');
SELECT 'Y'
FROM DUAL
WHERE EXISTS (SELECT id
FROM OKL_TRX_CONTRACTS
WHERE khr_id = p_khr_id
AND tmt_status_code NOT IN ('PROCESSED', 'CANCELED') --akrangan changed
--tsu_code to tmt_status_code
AND tcn_type IN ('TMT')
--rkuttiya added for 12.1.1 Multi GAAP Project
AND representation_type = 'PRIMARY');
SELECT tax_amount
FROM okl_cs_alc_summary_uv
WHERE dnz_cle_id = cp_top_line_id
AND tsu_code = 'PROCESSED';
SELECT request_id
FROM okl_cs_alc_summary_uv
WHERE dnz_cle_id = cp_top_line_id
AND tsu_code = 'PROCESSED';
SELECT mtl.serial_number_control_code
FROM okc_k_lines_b line,
okc_line_styles_b style,
okc_k_items kitem,
mtl_system_items mtl
WHERE line.lse_id = style.id
AND style.lty_code = 'ITEM'
AND line.id = kitem.cle_id
AND kitem.jtot_object1_code = 'OKX_SYSITEM'
AND kitem.object1_id1 = mtl.inventory_item_id
AND kitem.object1_id2 = TO_CHAR(mtl.organization_id)
AND line.cle_id = p_line_id;
SELECT DATE_EFFECTIVE
FROM okl_cs_alc_summary_uv
WHERE dnz_cle_id = cp_top_line_id
AND tsu_code = 'PROCESSED';
SELECT TSU_CODE
FROM okl_cs_alc_summary_uv
WHERE dnz_cle_id = cp_top_line_id;
SELECT trx.Id
FROM Okl_trx_Assets trx,
Okl_txl_Itm_Insts txl,
Okl_trx_Types_v Try
WHERE trx.Id = txl.tAs_Id
AND trx.Try_Id = Try.Id
AND Try.NAME = 'Asset Relocation'
AND trx.tsu_code = 'PROCESSED'
AND txl.dnz_cle_id = cp_top_line_id
ORDER BY trx.Date_tRans_OccurRed DESC;
SELECT start_date
FROM okc_k_headers_b
WHERE id = p_khr_id;
SELECT fbc.book_type_code
FROM fa_deprn_summary fds,
fa_book_controls fbc
WHERE fbc.book_class = 'CORPORATE'
AND fds.book_type_code = fbc.book_type_code
AND fds.asset_id = p_ast_id
and rownum = 1;
SELECT CURRENT_UNITS
FROM fa_additions
WHERE asset_id = p_ast_id;