[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT contract_number
FROM OKC_K_HEADERS_B
WHERE id = p_ctr_id1;
SELECT DNZ_CHR_ID
FROM OKC_K_LINES_B
WHERE ID = p_kle_id1;
select TO_CHAR(OKL_IBN_SEQ.NEXTVAL)
FROM dual;
select p_old_asset_number||'_'||OKL_FAN_SEQ.NEXTVAL
FROM dual;
select 'OKL'||OKL_FAN_SEQ.NEXTVAL
FROM dual;
SELECT 1
FROM DUAL
WHERE EXISTS (SELECT '1'
FROM OKL_TXL_ASSETS_B
WHERE asset_number = p_asset_number);
SELECT 1
FROM DUAL
WHERE EXISTS (SELECT '1'
FROM OKX_ASSET_LINES_V
WHERE asset_number = p_asset_number);
SELECT 1
FROM DUAL
WHERE EXISTS (SELECT '1'
FROM OKX_ASSETS_V
WHERE asset_number = p_asset_number);
SELECT cle.cle_id
,cle.chr_id
,lse.lty_code
,lse.lse_type
FROM okc_k_lines_b cle,
okc_line_styles_v lse
WHERE cle.lse_id = lse.id
AND cle.id = p_cle_id;
SELECT cle.id,
cle.dnz_chr_id
FROM okc_line_styles_b lse,
okc_k_lines_v cle
WHERE cle.cle_id = p_cle_id
AND lse.id = cle.lse_id
AND lse.lty_code = G_FA_LINE_LTY_CODE;
SELECT cle_ib.id,
cle_ib.dnz_chr_id
FROM okc_line_styles_b lse_ib,
okc_k_lines_b cle_ib,
okc_line_styles_b lse_inst,
okc_k_lines_b cle_inst
WHERE cle_inst.cle_id = p_cle_id
AND cle_inst.lse_id = lse_inst.id
AND lse_inst.lty_code = G_INST_LINE_LTY_CODE
AND cle_ib.cle_id = cle_inst.id
AND cle_ib.lse_id = lse_ib.id
AND lse_ib.lty_code = G_IB_LINE_LTY_CODE;
SELECT object1_id1,
object1_id2
FROM okc_k_items_v cim
WHERE cim.cle_id = p_cle_id
AND cim.dnz_chr_id = p_dnz_chr_id
AND cim.object1_id1 IS NOT NULL
AND cim.object1_id2 IS NOT NULL;
SELECT ID,
OBJECT_VERSION_NUMBER,
SFWT_FLAG,
CHR_ID,
CLE_ID,
LSE_ID,
LINE_NUMBER,
STS_CODE,
DISPLAY_SEQUENCE,
TRN_CODE,
DNZ_CHR_ID,
COMMENTS,
ITEM_DESCRIPTION,
OKE_BOE_DESCRIPTION,
COGNOMEN,
HIDDEN_IND,
PRICE_UNIT,
PRICE_UNIT_PERCENT,
PRICE_NEGOTIATED,
PRICE_NEGOTIATED_RENEWED,
PRICE_LEVEL_IND,
INVOICE_LINE_LEVEL_IND,
DPAS_RATING,
BLOCK23TEXT,
EXCEPTION_YN,
TEMPLATE_USED,
DATE_TERMINATED,
NAME,
START_DATE,
END_DATE,
DATE_RENEWED,
UPG_ORIG_SYSTEM_REF,
UPG_ORIG_SYSTEM_REF_ID,
ORIG_SYSTEM_SOURCE_CODE,
ORIG_SYSTEM_ID1,
ORIG_SYSTEM_REFERENCE1,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
PRICE_LIST_ID,
PRICING_DATE,
PRICE_LIST_LINE_ID,
LINE_LIST_PRICE,
ITEM_TO_PRICE_YN,
PRICE_BASIS_YN,
CONFIG_HEADER_ID,
CONFIG_REVISION_NUMBER,
CONFIG_COMPLETE_YN,
CONFIG_VALID_YN,
CONFIG_TOP_MODEL_LINE_ID,
CONFIG_ITEM_TYPE,
CONFIG_ITEM_ID ,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
PRICE_TYPE,
CURRENCY_CODE,
CURRENCY_CODE_RENEWED,
LAST_UPDATE_LOGIN
FROM Okc_K_Lines_V
WHERE okc_k_lines_v.id = p_cle_id;
x_clev_rec.program_update_date,
x_clev_rec.price_list_id,
x_clev_rec.pricing_date,
x_clev_rec.price_list_line_id,
x_clev_rec.line_list_price,
x_clev_rec.item_to_price_yn,
x_clev_rec.price_basis_yn,
x_clev_rec.config_header_id,
x_clev_rec.config_revision_number,
x_clev_rec.config_complete_yn,
x_clev_rec.config_valid_yn,
x_clev_rec.config_top_model_line_id,
x_clev_rec.config_item_type,
x_clev_rec.CONFIG_ITEM_ID ,
x_clev_rec.ATTRIBUTE_CATEGORY,
x_clev_rec.ATTRIBUTE1,
x_clev_rec.ATTRIBUTE2,
x_clev_rec.ATTRIBUTE3,
x_clev_rec.ATTRIBUTE4,
x_clev_rec.ATTRIBUTE5,
x_clev_rec.ATTRIBUTE6,
x_clev_rec.ATTRIBUTE7,
x_clev_rec.ATTRIBUTE8,
x_clev_rec.ATTRIBUTE9,
x_clev_rec.ATTRIBUTE10,
x_clev_rec.ATTRIBUTE11,
x_clev_rec.ATTRIBUTE12,
x_clev_rec.ATTRIBUTE13,
x_clev_rec.ATTRIBUTE14,
x_clev_rec.ATTRIBUTE15,
x_clev_rec.CREATED_BY,
x_clev_rec.CREATION_DATE,
x_clev_rec.LAST_UPDATED_BY,
x_clev_rec.LAST_UPDATE_DATE,
x_clev_rec.PRICE_TYPE,
x_clev_rec.CURRENCY_CODE,
x_clev_rec.CURRENCY_CODE_RENEWED,
x_clev_rec.LAST_UPDATE_LOGIN;
SELECT ID,
OBJECT_VERSION_NUMBER,
KLE_ID,
STY_ID,
PRC_CODE,
FCG_CODE,
NTY_CODE,
ESTIMATED_OEC,
LAO_AMOUNT,
TITLE_DATE,
FEE_CHARGE,
LRS_PERCENT,
INITIAL_DIRECT_COST,
PERCENT_STAKE,
PERCENT,
EVERGREEN_PERCENT,
AMOUNT_STAKE,
OCCUPANCY,
COVERAGE,
RESIDUAL_PERCENTAGE,
DATE_LAST_INSPECTION,
DATE_SOLD,
LRV_AMOUNT,
CAPITAL_REDUCTION,
DATE_NEXT_INSPECTION_DUE,
DATE_RESIDUAL_LAST_REVIEW,
DATE_LAST_REAMORTISATION,
VENDOR_ADVANCE_PAID,
WEIGHTED_AVERAGE_LIFE,
TRADEIN_AMOUNT,
BOND_EQUIVALENT_YIELD,
TERMINATION_PURCHASE_AMOUNT,
REFINANCE_AMOUNT,
YEAR_BUILT,
DELIVERED_DATE,
CREDIT_TENANT_YN,
DATE_LAST_CLEANUP,
YEAR_OF_MANUFACTURE,
COVERAGE_RATIO,
REMARKETED_AMOUNT,
GROSS_SQUARE_FOOTAGE,
PRESCRIBED_ASSET_YN,
DATE_REMARKETED,
NET_RENTABLE,
REMARKET_MARGIN,
DATE_LETTER_ACCEPTANCE,
REPURCHASED_AMOUNT,
DATE_COMMITMENT_EXPIRATION,
DATE_REPURCHASED,
DATE_APPRAISAL,
RESIDUAL_VALUE,
APPRAISAL_VALUE,
SECURED_DEAL_YN,
GAIN_LOSS,
FLOOR_AMOUNT,
RE_LEASE_YN,
PREVIOUS_CONTRACT,
TRACKED_RESIDUAL,
DATE_TITLE_RECEIVED,
AMOUNT,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
STY_ID_FOR,
CLG_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
DATE_FUNDING,
DATE_FUNDING_REQUIRED,
DATE_ACCEPTED,
DATE_DELIVERY_EXPECTED,
OEC,
CAPITAL_AMOUNT,
RESIDUAL_GRNTY_AMOUNT,
RESIDUAL_CODE,
RVI_PREMIUM,
CREDIT_NATURE,
CAPITALIZED_INTEREST,
CAPITAL_REDUCTION_PERCENT,
--Bug# 2998115:
DATE_PAY_INVESTOR_START,
PAY_INVESTOR_FREQUENCY,
PAY_INVESTOR_EVENT,
PAY_INVESTOR_REMITTANCE_DAYS,
FEE_TYPE,
--Bug#3143522 Subsidies :
SUBSIDY_ID,
--SUBSIDIZED_OEC,
--SUBSIDIZED_CAP_AMOUNT,
PRE_TAX_YIELD,
AFTER_TAX_YIELD,
IMPLICIT_INTEREST_RATE,
IMPLICIT_NON_IDC_INTEREST_RATE,
PRE_TAX_IRR,
AFTER_TAX_IRR,
SUBSIDY_OVERRIDE_AMOUNT,
--quote
SUB_PRE_TAX_YIELD,
SUB_AFTER_TAX_YIELD,
SUB_IMPL_INTEREST_RATE,
SUB_IMPL_NON_IDC_INT_RATE,
SUB_PRE_TAX_IRR,
SUB_AFTER_TAX_IRR,
--Bug# 2994971
ITEM_INSURANCE_CATEGORY,
--Bug# 3973640 : 11.510+ schema
QTE_ID,
FUNDING_DATE,
STREAM_TYPE_SUBCLASS
--ramurt Bug#4552772
,FEE_PURPOSE_CODE
FROM OKL_K_LINES_V
WHERE OKL_K_LINES_V.id = p_kle_id;
x_klev_rec.LAST_UPDATED_BY,
x_klev_rec.LAST_UPDATE_DATE,
x_klev_rec.LAST_UPDATE_LOGIN,
x_klev_rec.DATE_FUNDING,
x_klev_rec.DATE_FUNDING_REQUIRED,
x_klev_rec.DATE_ACCEPTED,
x_klev_rec.DATE_DELIVERY_EXPECTED,
x_klev_rec.OEC,
x_klev_rec.CAPITAL_AMOUNT,
x_klev_rec.RESIDUAL_GRNTY_AMOUNT,
x_klev_rec.RESIDUAL_CODE,
x_klev_rec.RVI_PREMIUM,
x_klev_rec.CREDIT_NATURE,
x_klev_rec.CAPITALIZED_INTEREST,
x_klev_rec.CAPITAL_REDUCTION_PERCENT,
--Bug# 2998115 :
x_klev_rec.DATE_PAY_INVESTOR_START,
x_klev_rec.PAY_INVESTOR_FREQUENCY,
x_klev_rec.PAY_INVESTOR_EVENT,
x_klev_rec.PAY_INVESTOR_REMITTANCE_DAYS,
x_klev_rec.FEE_TYPE,
--Bug#3143522 Subsidies :
x_klev_rec.SUBSIDY_ID,
--x_klev_rec.SUBSIDIZED_OEC,
--x_klev_rec.SUBSIDIZED_CAP_AMOUNT,
x_klev_rec.PRE_TAX_YIELD,
x_klev_rec.AFTER_TAX_YIELD,
x_klev_rec.IMPLICIT_INTEREST_RATE,
x_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
x_klev_rec.PRE_TAX_IRR,
x_klev_rec.AFTER_TAX_IRR,
x_klev_rec.SUBSIDY_OVERRIDE_AMOUNT,
--quote
x_klev_rec.SUB_PRE_TAX_YIELD,
x_klev_rec.SUB_AFTER_TAX_YIELD,
x_klev_rec.SUB_IMPL_INTEREST_RATE,
x_klev_rec.SUB_IMPL_NON_IDC_INT_RATE,
x_klev_rec.SUB_PRE_TAX_IRR,
x_klev_rec.SUB_AFTER_TAX_IRR,
--Bug# 2994971 :
x_klev_rec.ITEM_INSURANCE_CATEGORY,
--Bug# 3973640 : 11.510+ schema
x_klev_rec.QTE_ID,
x_klev_rec.FUNDING_DATE,
x_klev_rec.STREAM_TYPE_SUBCLASS
--ramurt Bug#4552772
,x_klev_rec.FEE_PURPOSE_CODE;
SELECT ID,
OBJECT_VERSION_NUMBER,
ICA_ID,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
TAS_TYPE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
TSU_CODE,
TRY_ID,
DATE_TRANS_OCCURRED,
TRANS_NUMBER,
COMMENTS,
REQ_ASSET_ID,
TOTAL_MATCH_AMOUNT
FROM OKL_TRX_ASSETS
WHERE id = p_tas_id;
x_trxv_rec.LAST_UPDATED_BY,
x_trxv_rec.LAST_UPDATE_DATE,
x_trxv_rec.LAST_UPDATE_LOGIN,
x_trxv_rec.TSU_CODE,
x_trxv_rec.TRY_ID,
x_trxv_rec.DATE_TRANS_OCCURRED,
x_trxv_rec.TRANS_NUMBER,
x_trxv_rec.COMMENTS,
x_trxv_rec.REQ_ASSET_ID,
x_trxv_rec.TOTAL_MATCH_AMOUNT;
SELECT ID,
OBJECT_VERSION_NUMBER,
CLE_ID,
FA_CLE_ID,
INVOICE_NUMBER,
DATE_INVOICED,
DATE_DUE,
SHIPPING_ADDRESS_ID1,
SHIPPING_ADDRESS_ID2,
SHIPPING_ADDRESS_CODE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
FROM Okl_Supp_Invoice_Dtls_V sid
WHERE sid.cle_id = p_id;
x_sidv_rec.last_updated_by,
x_sidv_rec.last_update_date,
x_sidv_rec.last_update_login;
SELECT ID,
OBJECT_VERSION_NUMBER,
SFWT_FLAG,
TAS_ID,
ILO_ID,
ILO_ID_OLD,
IAY_ID,
IAY_ID_NEW,
KLE_ID,
DNZ_KHR_ID,
LINE_NUMBER,
ORG_ID,
TAL_TYPE,
ASSET_NUMBER,
DESCRIPTION,
FA_LOCATION_ID,
ORIGINAL_COST,
CURRENT_UNITS,
MANUFACTURER_NAME,
YEAR_MANUFACTURED,
SUPPLIER_ID,
USED_ASSET_YN,
TAG_NUMBER,
MODEL_NUMBER,
CORPORATE_BOOK,
DATE_PURCHASED,
DATE_DELIVERY,
IN_SERVICE_DATE,
LIFE_IN_MONTHS,
DEPRECIATION_ID,
DEPRECIATION_COST,
DEPRN_METHOD,
DEPRN_RATE,
SALVAGE_VALUE,
PERCENT_SALVAGE_VALUE,
--Bug# 2981308
ASSET_KEY_ID,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
DEPRECIATE_YN,
HOLD_PERIOD_DAYS,
OLD_SALVAGE_VALUE,
NEW_RESIDUAL_VALUE,
OLD_RESIDUAL_VALUE,
UNITS_RETIRED,
COST_RETIRED,
SALE_PROCEEDS,
REMOVAL_COST,
DNZ_ASSET_ID,
DATE_DUE,
REP_ASSET_ID,
LKE_ASSET_ID,
MATCH_AMOUNT,
SPLIT_INTO_SINGLES_FLAG,
SPLIT_INTO_UNITS,
-- Multi-Currency Change
CURRENCY_CODE,
CURRENCY_CONVERSION_TYPE,
CURRENCY_CONVERSION_RATE,
CURRENCY_CONVERSION_DATE
-- Multi-Currency Change
FROM Okl_Txl_Assets_V tal
WHERE tal.kle_id = p_kle_id;
x_txlv_rec.LAST_UPDATED_BY,
x_txlv_rec.LAST_UPDATE_DATE,
x_txlv_rec.LAST_UPDATE_LOGIN,
x_txlv_rec.DEPRECIATE_YN,
x_txlv_rec.HOLD_PERIOD_DAYS,
x_txlv_rec.OLD_SALVAGE_VALUE,
x_txlv_rec.NEW_RESIDUAL_VALUE,
x_txlv_rec.OLD_RESIDUAL_VALUE,
x_txlv_rec.UNITS_RETIRED,
x_txlv_rec.COST_RETIRED,
x_txlv_rec.SALE_PROCEEDS,
x_txlv_rec.REMOVAL_COST,
x_txlv_rec.DNZ_ASSET_ID,
x_txlv_rec.DATE_DUE,
x_txlv_rec.REP_ASSET_ID,
x_txlv_rec.LKE_ASSET_ID,
x_txlv_rec.MATCH_AMOUNT,
x_txlv_rec.SPLIT_INTO_SINGLES_FLAG,
x_txlv_rec.SPLIT_INTO_UNITS,
-- Multi-Currency Change
x_txlv_rec.CURRENCY_CODE,
x_txlv_rec.CURRENCY_CONVERSION_TYPE,
x_txlv_rec.CURRENCY_CONVERSION_RATE,
x_txlv_rec.CURRENCY_CONVERSION_DATE;
SELECT id,
object_version_number,
tal_id,
target_kle_id,
line_detail_number,
asset_number,
description,
quantity,
cost,
tax_book,
life_in_months_tax,
deprn_method_tax,
deprn_rate_tax,
salvage_value,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
split_percent,
inventory_item_id ,
-- Multi-Currency Change
currency_code,
currency_conversion_type,
currency_conversion_rate,
currency_conversion_date
-- Multi-Currency Change
FROM Okl_Txd_Assets_V txd
WHERE txd.tal_id = p_tal_id;
x_txdv_tbl(i).LAST_UPDATED_BY := r_okl_asdv_pk_csr.LAST_UPDATED_BY;
x_txdv_tbl(i).LAST_UPDATE_DATE := r_okl_asdv_pk_csr.LAST_UPDATE_DATE;
x_txdv_tbl(i).LAST_UPDATE_LOGIN := r_okl_asdv_pk_csr.LAST_UPDATE_LOGIN;
SELECT ID,
OBJECT_VERSION_NUMBER,
TAS_ID,
TAL_ID,
KLE_ID,
TAL_TYPE,
LINE_NUMBER,
INSTANCE_NUMBER_IB,
OBJECT_ID1_NEW,
OBJECT_ID2_NEW,
JTOT_OBJECT_CODE_NEW,
OBJECT_ID1_OLD,
OBJECT_ID2_OLD,
JTOT_OBJECT_CODE_OLD,
INVENTORY_ORG_ID,
SERIAL_NUMBER,
MFG_SERIAL_NUMBER_YN,
INVENTORY_ITEM_ID,
INV_MASTER_ORG_ID,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
FROM OKL_TXL_ITM_INSTS iti
WHERE iti.kle_id = p_kle_id;
x_itiv_rec.LAST_UPDATED_BY,
x_itiv_rec.LAST_UPDATE_DATE,
x_itiv_rec.LAST_UPDATE_LOGIN;
SELECT id
FROM OKL_TRX_TYPES_tl
WHERE upper(name) = upper(p_try_name)
AND language = G_LANGUAGE;
SELECT CIM.ID,
CIM.OBJECT_VERSION_NUMBER,
CIM.CLE_ID,
CIM.CHR_ID,
CIM.CLE_ID_FOR,
CIM.DNZ_CHR_ID,
CIM.OBJECT1_ID1,
CIM.OBJECT1_ID2,
CIM.JTOT_OBJECT1_CODE,
CIM.UOM_CODE,
CIM.EXCEPTION_YN,
CIM.NUMBER_OF_ITEMS,
CIM.UPG_ORIG_SYSTEM_REF,
CIM.UPG_ORIG_SYSTEM_REF_ID,
CIM.PRICED_ITEM_YN,
CIM.CREATED_BY,
CIM.CREATION_DATE,
CIM.LAST_UPDATED_BY,
CIM.LAST_UPDATE_DATE,
CIM.LAST_UPDATE_LOGIN
FROM okc_k_items_v cim
WHERE cim.dnz_chr_id = p_dnz_chr_id
AND cim.cle_id = p_cle_id;
x_cimv_rec.LAST_UPDATED_BY,
x_cimv_rec.LAST_UPDATE_DATE,
x_cimv_rec.LAST_UPDATE_LOGIN;
PROCEDURE Update_asset_header(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_trxv_rec IN trxv_rec_type,
x_trxv_rec OUT NOCOPY trxv_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TRX_ASSET_HEADER';
OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_thpv_rec => p_trxv_rec,
x_thpv_rec => x_trxv_rec);
END Update_asset_header;
SELECT 1
FROM DUAL
WHERE EXISTS (SELECT 1
FROM OKL_SUPP_INVOICE_DTLS_V
WHERE cle_id = p_cle_id);
SELECT cle_ml.id ml_cle_id,
cle_fa.id fa_cle_id
FROM OKC_K_LINES_V cle_fa,
OKC_LINE_STYLES_V lse_fa,
OKC_K_LINES_V cle_ml,
OKC_LINE_STYLES_V lse_ml
WHERE cle_ml.cle_id = p_cle_id
AND cle_ml.lse_id = lse_ml.id
AND lse_ml.lty_code = G_MODEL_LINE_LTY_CODE
AND cle_fa.cle_id = cle_ml.cle_id
AND cle_fa.dnz_chr_id = cle_ml.dnz_chr_id
AND cle_fa.lse_id = lse_fa.id
AND lse_fa.lty_code = G_FA_LINE_LTY_CODE;
SELECT cle_ad.id ad_cle_id,
cle_fa.id fa_cle_id
FROM OKC_K_LINES_V cle_ad,
OKC_LINE_STYLES_V lse_ad,
OKC_K_LINES_V cle_fa,
OKC_LINE_STYLES_V lse_fa,
OKC_K_LINES_V cle_ml,
OKC_LINE_STYLES_V lse_ml
WHERE cle_ml.cle_id = p_cle_id
AND cle_ml.lse_id = lse_ml.id
AND lse_ml.lty_code = G_MODEL_LINE_LTY_CODE
AND cle_fa.cle_id = cle_ml.cle_id
AND cle_fa.dnz_chr_id = cle_ml.dnz_chr_id
AND cle_fa.lse_id = lse_fa.id
AND lse_fa.lty_code = G_FA_LINE_LTY_CODE
AND cle_ad.cle_id = cle_ml.id
AND cle_ad.dnz_chr_id = cle_ml.dnz_chr_id
AND cle_ad.lse_id = lse_ad.id
AND lse_ad.lty_code = G_ADDON_LINE_LTY_CODE;
SELECT cle_ad.id ad_cle_id,
cle_fa.id fa_cle_id
FROM OKC_K_LINES_V cle_ad,
OKC_LINE_STYLES_V lse_ad,
OKC_K_LINES_V cle_fa,
OKC_LINE_STYLES_V lse_fa,
OKC_K_LINES_V cle_ml,
OKC_LINE_STYLES_V lse_ml
WHERE cle_ml.cle_id = p_cle_id
AND cle_ml.lse_id = lse_ml.id
AND lse_ml.lty_code = G_MODEL_LINE_LTY_CODE
AND cle_fa.cle_id = cle_ml.cle_id
AND cle_fa.dnz_chr_id = cle_ml.dnz_chr_id
AND cle_fa.lse_id = lse_fa.id
AND lse_fa.lty_code = G_FA_LINE_LTY_CODE
AND cle_ad.cle_id = cle_ml.id
AND cle_ad.orig_system_id1 = p_orig_cle_id
AND cle_ad.dnz_chr_id = cle_ml.dnz_chr_id
AND cle_ad.lse_id = lse_ad.id
AND lse_ad.lty_code = G_ADDON_LINE_LTY_CODE;
Update_asset_header(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_trxv_rec => l_trxv_rec,
x_trxv_rec => x_trxv_rec);
Update_asset_header(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_trxv_rec => l_trxv_rec,
x_trxv_rec => x_trxv_rec);
SELECT 1
FROM DUAL
WHERE EXISTS (SELECT '1'
FROM OKL_TXD_ASSETS_V
WHERE tal_id = p_tal_id);
SELECT cle.id
FROM OKC_K_LINES_V cle,
OKC_LINE_STYLES_V lse
WHERE cle.cle_id = p_cle_id
AND cle.dnz_chr_id = p_dnz_chr_id
AND cle.lse_id = lse.id
AND lse.lty_code = G_FA_LINE_LTY_CODE;
Update_asset_header(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_trxv_rec => l_trxv_rec,
x_trxv_rec => x_trxv_rec);
Update_asset_header(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_trxv_rec => l_trxv_rec,
x_trxv_rec => x_trxv_rec);
Select fin_tl.name Asset_Number,
fin_tl.item_description description,
mdl_cle.price_unit unit_price,
mdl_cim.number_of_items units,
fin_kle.oec oec,
fa_kle.year_built Year_of_Manufacture
From okc_k_items mdl_cim,
okc_k_lines_b mdl_cle,
okc_line_styles_b mdl_lse,
okl_k_lines fin_kle,
okc_k_lines_tl fin_tl,
okc_k_lines_b fin_cle,
okc_line_styles_b fin_lse,
okl_k_lines fa_kle,
okc_k_lines_b fa_cle,
okc_line_styles_b fa_lse
where mdl_cim.cle_id = mdl_cle.id
and mdl_cim.dnz_chr_id = mdl_cle.dnz_chr_id
and mdl_cle.cle_id = fin_cle.id
and mdl_cle.dnz_chr_id = fin_cle.dnz_chr_id
and mdl_cle.lse_id = mdl_lse.id
and mdl_lse.lty_code = 'ITEM'
and fin_kle.id = fin_cle.id
and fin_tl.id = fin_cle.id
and fin_tl.language = USERENV('LANG')
and fin_cle.lse_id = fin_lse.id
and fin_lse.lty_code = 'FREE_FORM1'
and fin_cle.id = fa_cle.cle_id
and fin_cle.dnz_chr_id = fa_cle.dnz_chr_id
and fa_kle.id = fa_cle.id
and fa_cle.lse_id = fa_lse.id
and fa_lse.lty_code = 'FIXED_ASSET'
and fa_cle.id = p_fa_cle_id
and fa_cle.dnz_chr_id = p_chr_id;
SELECT id
FROM OKL_TRX_TYPES_tl
WHERE upper(name) = upper(p_try_name)
AND language = 'US';
SELECT cle.id
FROM OKC_K_LINES_V cle,
OKC_LINE_STYLES_V lse
WHERE cle.cle_id = p_cle_id
AND cle.dnz_chr_id = p_dnz_chr_id
AND cle.lse_id = lse.id
AND lse.lty_code = G_FA_LINE_LTY_CODE;
Update_asset_header(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_trxv_rec => l_trxv_rec,
x_trxv_rec => x_trxv_rec);
Update_asset_header(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_trxv_rec => l_trxv_rec,
x_trxv_rec => x_trxv_rec);
SELECT cle.id
FROM OKC_K_LINES_V cle,
OKC_LINE_STYLES_V lse
WHERE cle.dnz_chr_id = p_dnz_chr_id
AND cle.lse_id = lse.id
AND lse.lty_code = G_IB_LINE_LTY_CODE
AND cle.cle_id in (SELECT cle.id
FROM OKC_K_LINES_V cle,
OKC_LINE_STYLES_V lse
WHERE cle.cle_id = p_cle_id
AND cle.lse_id = lse.id
AND lse.lty_code = G_INST_LINE_LTY_CODE
AND cle.dnz_chr_id = p_dnz_chr_id);
Update_asset_header(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_trxv_rec => l_trxv_rec,
x_trxv_rec => x_trxv_rec);
Update_asset_header(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_trxv_rec => l_trxv_rec,
x_trxv_rec => x_trxv_rec);
select ppyd.cpl_id
,ppyd.vendor_id
,ppyd.PAY_SITE_ID
,ppyd.PAYMENT_TERM_ID
,ppyd.PAYMENT_METHOD_CODE
,ppyd.PAY_GROUP_CODE
,ppyd.ATTRIBUTE_CATEGORY
,ppyd.ATTRIBUTE1
,ppyd.ATTRIBUTE2
,ppyd.ATTRIBUTE3
,ppyd.ATTRIBUTE4
,ppyd.ATTRIBUTE5
,ppyd.ATTRIBUTE6
,ppyd.ATTRIBUTE7
,ppyd.ATTRIBUTE8
,ppyd.ATTRIBUTE9
,ppyd.ATTRIBUTE10
,ppyd.ATTRIBUTE11
,ppyd.ATTRIBUTE12
,ppyd.ATTRIBUTE13
,ppyd.ATTRIBUTE14
,ppyd.ATTRIBUTE15
,cleb_sub.id subsidy_cle_id
from okl_party_payment_dtls ppyd,
okc_k_party_roles_b cplb,
okc_k_lines_b cleb_sub
where ppyd.cpl_id = cplb.id
and cplb.cle_id = cleb_sub.id
and cleb_sub.cle_id = p_from_cle_id
and cleb_sub.sts_code <> 'ABANDONED';
select cplb.id
from okc_k_party_roles_b cplb,
okc_k_lines_b cleb_sub
where cplb.cle_id = cleb_sub.id
and cleb_sub.cle_id = p_to_cle_id
and cleb_sub.orig_system_id1 = p_parent_cle_id
and cleb_sub.dnz_chr_id = cleb_sub.dnz_chr_id
and cleb_sub.sts_code <> 'ABANDONED';
OKL_PYD_PVT.Insert_Row
(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_ppydv_rec => l_ppydv_rec,
x_ppydv_rec => x_ppydv_rec);
select kle_fin.item_insurance_category,
cim_model.object1_id1,
cim_model.object1_id2
from okc_k_items cim_model,
okc_k_lines_b cleb_model,
okc_line_styles_b lseb_model,
okl_k_lines kle_fin
where cim_model.cle_id = cleb_model.id
and cleb_model.cle_id = p_cle_id
and lseb_model.id = cleb_model.lse_id
and lseb_model.lty_code = 'ITEM'
and kle_fin.id = p_cle_id;
select msi.asset_category_id
from mtl_system_items msi
where msi.organization_id = p_inv_org_id
and msi.inventory_item_id = p_inv_item_id;
okl_contract_pub.update_contract_line(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_clev_rec => l_clev_rec,
p_klev_rec => l_klev_rec,
x_clev_rec => lx_clev_rec,
x_klev_rec => lx_klev_rec
);
Select khr.id,
khr.authoring_org_id,
khr.currency_code,
khr.start_date
From OKL_K_LINES_FULL_V kle,
OKL_K_HEADERS_FULL_V KHR
Where kle.id = cleId
and KHR.ID = KLE.DNZ_CHR_ID;
SELECT 1
FROM DUAL
WHERE EXISTS (SELECT '1'
FROM OKL_TXL_ASSETS_V
WHERE kle_Id = p_fa_kle_id);
SELECT 1
FROM DUAL
WHERE EXISTS (SELECT '1'
FROM OKL_TXL_ITM_INSTS_V
WHERE kle_id = p_ib_kle_id);
SELECT *
FROM OKX_ASSETS_V
WHERE id1 = p_object1_id1
AND id2 = p_object1_id2;
SELECT location_id
FROM OKX_AST_DST_HST_V
WHERE asset_id = p_asset_id
AND transaction_header_id_out is null
AND sysdate between start_date_active and nvl(end_date_active,sysdate+1)
AND rownum < 2;
SELECT *
FROM OKX_AST_BKS_V
WHERE id1 = p_object1_id1
AND book_class = 'TAX';
SELECT *
FROM OKX_INSTALL_ITEMS_V
WHERE id1 = p_object1_id1
AND id2 = p_object1_id2;
SELECT cle.id
FROM OKC_K_LINES_V cle,
OKC_LINE_STYLES_V lse
WHERE cle.cle_id = p_cle_id
AND cle.dnz_chr_id = p_dnz_chr_id
AND cle.lse_id = lse.id
AND lse.lty_code = G_FA_LINE_LTY_CODE;
SELECT kle.Year_Built
FROM OKL_K_LINES_V kle
WHERE kle.id = p_kle_id;
SELECT cle.id,
cle.dnz_chr_id
FROM OKC_K_LINES_V cle,
OKC_LINE_STYLES_V lse
WHERE cle.dnz_chr_id = p_dnz_chr_id
AND cle.lse_id = lse.id
AND lse.lty_code = G_IB_LINE_LTY_CODE
AND cle.cle_id in (SELECT cle.id
FROM OKC_K_LINES_V cle,
OKC_LINE_STYLES_V lse
WHERE cle.cle_id = p_cle_id
AND cle.lse_id = lse.id
AND lse.lty_code = G_INST_LINE_LTY_CODE
AND cle.dnz_chr_id = p_dnz_chr_id);
SELECT cim.object1_id1,
cim.object1_id2
FROM OKC_LINE_STYLES_V lse,
OKC_K_ITEMS_V cim,
OKC_K_LINES_V cle
WHERE cle.dnz_chr_id = p_dnz_chr_id
AND cle.cle_id = p_cle_id
AND cle.id = cim.cle_id
AND cle.dnz_chr_id = cim.dnz_chr_id
AND cle.lse_id = lse.id
AND lse.lty_code = G_MODEL_LINE_LTY_CODE;
SELECT psu.party_site_use_id
FROM HZ_PARTY_SITE_USES psu,
HZ_PARTY_SITES ps
WHERE ps.party_site_id = psu.party_site_id
AND psu.site_use_type = 'INSTALL_AT'
AND psu.party_site_id = p_party_site_id;
SELECT install_location_type_code,
owner_party_id
FROM csi_item_instances
WHERE instance_id = p_instance_id;
SELECT psu.party_site_use_id
FROM hz_party_site_uses psu,
hz_party_sites ps
WHERE psu.party_site_id = ps.party_site_id
AND psu.site_use_type = 'INSTALL_AT'
AND ps.location_id = p_location_id;
select substr(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3, hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,null,hl.country,null, null,null,null,null,null,null,'n','n',80,1,1),1,80)
from hz_locations hl,
hz_party_sites ps
where hl.location_id = ps.location_id
and ps.party_site_id = pty_site_id;
select substr(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3, hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,null,hl.country,null, null,null,null,null,null,null,'n','n',80,1,1),1,80)
from hz_locations hl
where hl.location_id = loc_id;
SELECT khrv.deal_type,
klev.oec
FROM okl_k_headers_v khrv,
okc_subclass_top_line stl,
okc_line_styles_b lse,
okc_k_lines_v cle,
okl_k_lines_v klev
WHERE cle.cle_id is null
AND cle.id = klev.id
AND cle.chr_id = cle.dnz_chr_id
AND cle.lse_id = lse.id
AND lse.lty_code = G_FIN_LINE_LTY_CODE
AND lse.lse_parent_id is null
AND lse.lse_type = G_TLS_TYPE
AND lse.id = stl.lse_Id
AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
AND cle.dnz_chr_id = khrv.id
AND cle.dnz_chr_id = p_dnz_chr_id
AND cle.id = p_top_line_id;
Select deal_type, sts_code
From okl_k_headers_full_v
Where id = p_chr_id;
select asset_key_ccid
from fa_additions_b
where asset_id = p_asset_id;
select 'Y'
from fa_methods
where method_code = p_deprn_method
and life_in_months = p_life_in_months
and life_in_months is not null;
select 'Y'
from fa_flat_rates ffr,
fa_methods fm
where fm.method_code = p_deprn_method
and ffr.method_id = fm.method_id
and ffr.adjusted_rate = p_rate
and ffr.adjusting_rate = 0;
OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cimv_rec => l_cimv_rec,
x_cimv_rec => lx_cimv_rec);
OKL_CONTRACT_PUB.update_contract_line(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_clev_rec => l_clev_rec,
p_klev_rec => l_klev_rec,
x_clev_rec => lx_clev_rec,
x_klev_rec => lx_klev_rec);
OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cimv_rec => l_cimv_rec,
x_cimv_rec => lx_cimv_rec);
okl_contract_pub.update_contract_line(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_clev_rec => l_fin_clev_rec,
p_klev_rec => l_fin_klev_rec,
x_clev_rec => lx_fin_clev_rec,
x_klev_rec => lx_fin_klev_rec);
SELECT new_cle.id
FROM OKC_K_LINES_B new_cle,
OKC_K_ITEMS orig_lnk_cim
WHERE
--Bug# 2998115 :
--Bug# 3868709 : Query fixed for Performance issue
((new_cle.ORIG_SYSTEM_ID1 = orig_lnk_cim.object1_id1)
OR
exists (select null
from OKC_K_LINES_B rbk_cle
where rbk_cle.id = orig_lnk_cim.object1_id1
AND rbk_cle.ORIG_SYSTEM_ID1 = new_cle.id)
)
AND new_cle.chr_id = p_new_chr_id
AND orig_lnk_cim.cle_id = p_orig_lnk_cle_id
AND orig_lnk_cim.jtot_object1_code = 'OKX_COVASST'
AND not exists (select null
from OKC_K_LINES_B another_cle
where another_cle.orig_system_id1 = new_cle.orig_system_id1
and another_cle.lse_id = new_cle.lse_id
and another_cle.chr_id = new_cle.chr_id
and another_cle.id <> new_cle.id);
select cov_ast_cim.object1_id1,
cov_ast_cim.dnz_chr_id
from okc_k_lines_b cov_ast_cleb,
okc_line_styles_b cov_ast_lseb,
okl_k_lines fee_kle,
okc_k_items cov_ast_cim
where fee_kle.id = cov_ast_cleb.cle_id
and fee_kle.fee_type = 'CAPITALIZED'
and cov_ast_lseb.id = cov_ast_cleb.lse_id
and cov_ast_lseb.lty_code = 'LINK_FEE_ASSET'
and cov_ast_cleb.id = cov_ast_cim.cle_id
and cov_ast_cim.id = p_cim_id
and cov_ast_cim.jtot_object1_code = 'OKX_COVASST'
--Bug# 4057305 : exclude the linked asset lines for which the asset does not
-- exist on the same contract
and exists (select '1'
from okc_k_lines_b fin_ast_cleb,
okc_line_styles_b fin_ast_lseb
where fin_ast_cleb.id = cov_ast_cim.object1_id1
and fin_ast_cleb.lse_id = fin_ast_lseb.id
and fin_ast_lseb.lty_code = 'FREE_FORM1'
and fin_ast_cleb.dnz_chr_id = cov_ast_cim.dnz_chr_id);
okl_okc_migration_pvt.update_contract_item(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cimv_rec => l_cimv_rec,
x_cimv_rec => lx_cimv_rec);
okl_contract_pub.update_contract_line(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_clev_rec => l_fin_clev_rec,
p_klev_rec => l_fin_klev_rec,
x_clev_rec => lx_fin_clev_rec,
x_klev_rec => lx_fin_klev_rec);
SELECT lse.lty_code,
cle.dnz_chr_id
FROM okc_line_styles_b lse,
okc_k_lines_b cle
WHERE cle.id = p_top_line_id
AND cle.lse_id = lse.id
AND lse.lse_parent_id is null
AND lse.lse_type = G_TLS_TYPE;
SELECT 'Y'
FROM okc_k_rel_objs
WHERE chr_id = p_chr_id
AND cle_id IS NULL
AND rty_code = 'OKLSRV'
AND jtot_object1_code = 'OKL_SERVICE';
SELECT cle_id,
chr_id,
rty_code,
object1_id1,
object1_id2,
jtot_object1_code
FROM okc_k_rel_objs
WHERE chr_id = p_chr_id
AND cle_id IS NULL
AND rty_code = 'OKLSRV'
AND jtot_object1_code = 'OKL_SERVICE';
SELECT rel.id,
rel.cle_id,
rel.chr_id,
rel.rty_code,
rel.object1_id1,
rel.object1_id2,
rel.jtot_object1_code
FROM okc_k_rel_objs rel
WHERE rty_code = 'OKLSRV'
AND cle_id is not null
AND jtot_object1_code = 'OKL_SERVICE_LINE'
AND cle_id = p_srv_top_line_id
UNION
SELECT rel.id,
rel.cle_id,
rel.chr_id,
rel.rty_code,
rel.object1_id1,
rel.object1_id2,
rel.jtot_object1_code
FROM okc_k_rel_objs rel,
okc_k_lines_b line
WHERE rty_code = 'OKLSRV'
AND rel.cle_id is not null
AND rel.jtot_object1_code = 'OKL_COV_PROD'
AND rel.cle_id = line.id
AND line.cle_id = p_srv_top_line_id;
SELECT id
FROM okc_k_lines_b
WHERE orig_system_id1 = p_line_id
AND dnz_chr_id = p_chr_id;
SELECT lse.lty_code,
cle.dnz_chr_id
FROM okc_line_styles_b lse,
okc_k_lines_b cle
WHERE cle.id = p_top_line_id
AND cle.lse_id = lse.id
AND lse.lse_parent_id is null
AND lse.lse_type = G_TLS_TYPE;
SELECT cle.id top_line_id
FROM okc_line_styles_b lse,
okc_k_lines_b cle
WHERE cle.dnz_chr_id = p_dnz_chr_id
AND cle.lse_id = lse.id
AND lse.lse_parent_id is null
AND lse.lse_type = G_TLS_TYPE
AND lse.lty_code in (G_FEE_LINE_LTY_CODE,G_SER_LINE_LTY_CODE,G_UBB_LINE_LTY_CODE);
SELECT level,
id,
dnz_chr_id,
orig_system_id1
FROM okc_k_lines_b
CONNECT BY PRIOR id = cle_id
START WITH id = p_cle_id;
SELECT new_lnk_cle.id,
new_lnk_cle.orig_system_id1,
new_lnk_cim.id,
new_lnk_cim.jtot_object1_code,
new_lnk_cim.object1_id1,
new_lnk_cim.object1_id2
FROM okc_k_items new_lnk_cim,
okc_k_lines_b new_lnk_cle
WHERE new_lnk_cim.cle_id = new_lnk_cle.id
AND new_lnk_cim.dnz_chr_id = new_lnk_cle.dnz_chr_id
--Bug# 4899328
-- To link cov assets when copying only sub-lines
--AND new_lnk_cle.cle_id = p_cle_id;
SELECT authoring_org_id,
inv_organization_id
FROM okc_k_headers_b
WHERE id = p_chr_id;