eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_QA_DATA_INTEGRITY dependencies on DUAL

Line 328: FROM DUAL

324: --Bug# 16681373: Commented out cursor
325: /*
326: CURSOR inactive_assets_csr(chrId IN NUMBER) IS
327: SELECT 'Y'
328: FROM DUAL
329: WHERE EXISTS
330: (
331: SELECT 1
332: FROM OKC_K_LINES_B fa_cle,

Line 3352: FROM DUAL;

3348: CURSOR c_num_of_disb(p_contract_end_date DATE, p_payout_date DATE, p_frequency VARCHAR2)
3349: IS
3350: SELECT CEIL(Months_between(p_contract_end_date, p_payout_date)/
3351: DECODE(p_frequency,'A',12,'S',6,'Q',3,1))
3352: FROM DUAL;
3353:
3354: l_fixed_amt okl_party_payment_dtls.disbursement_fixed_amount%TYPE;
3355: l_payout_basis okl_party_payment_hdr.payout_basis%TYPE;
3356: l_passthru_term okl_party_payment_hdr.passthru_term%TYPE;

Line 5132: *FROM dual;

5128:
5129: /*
5130: *CURSOR strm_profile_csr IS
5131: *SELECT fnd_profile.VALUE('OKL_STREAMS_GEN_PATH')
5132: *FROM dual;
5133: */
5134:
5135: l_strm_profile VARCHAR2(50);
5136: lx_return_status VARCHAR2(1);

Line 7186: -- Procedure Name : check_residual_value

7182: END check_stream_template;
7183:
7184: -- Start of comments
7185: --
7186: -- Procedure Name : check_residual_value
7187: -- Description : Bug#4186455
7188: -- : Throws a message if asset residual value is less than 20%
7189: -- : and tax owner for the contract is LESSOR. The message
7190: -- : is conifgurable to error or warning.

Line 7188: -- : Throws a message if asset residual value is less than 20%

7184: -- Start of comments
7185: --
7186: -- Procedure Name : check_residual_value
7187: -- Description : Bug#4186455
7188: -- : Throws a message if asset residual value is less than 20%
7189: -- : and tax owner for the contract is LESSOR. The message
7190: -- : is conifgurable to error or warning.
7191: -- Business Rules :
7192: -- Parameters :

Line 7196: PROCEDURE check_residual_value(

7192: -- Parameters :
7193: -- Version : 1.0
7194: -- End of comments
7195:
7196: PROCEDURE check_residual_value(
7197: x_return_status OUT NOCOPY VARCHAR2,
7198: p_chr_id IN NUMBER
7199: ) IS
7200:

Line 7230: IF (( nvl(l_lne.residual_value,0) < (0.2 * l_OEC)) AND (l_tax_owner = 'LESSOR')) THEN

7226: l_oec := l_lne.oec;
7227: end if;
7228:
7229: --Bug# 4631549
7230: IF (( nvl(l_lne.residual_value,0) < (0.2 * l_OEC)) AND (l_tax_owner = 'LESSOR')) THEN
7231: --IF (( NVL(l_lne.residual_value,0) < (0.2 * l_lne.OEC)) AND (l_tax_owner = 'LESSOR')) THEN
7232: Okl_Api.set_message(
7233: p_app_name => G_APP_NAME,
7234: p_msg_name => 'OKL_QA_RV_OEC_TOWN',

Line 7231: --IF (( NVL(l_lne.residual_value,0) < (0.2 * l_lne.OEC)) AND (l_tax_owner = 'LESSOR')) THEN

7227: end if;
7228:
7229: --Bug# 4631549
7230: IF (( nvl(l_lne.residual_value,0) < (0.2 * l_OEC)) AND (l_tax_owner = 'LESSOR')) THEN
7231: --IF (( NVL(l_lne.residual_value,0) < (0.2 * l_lne.OEC)) AND (l_tax_owner = 'LESSOR')) THEN
7232: Okl_Api.set_message(
7233: p_app_name => G_APP_NAME,
7234: p_msg_name => 'OKL_QA_RV_OEC_TOWN',
7235: p_token1 => 'line',

Line 7263: END check_residual_value;

7259: IF l_hdrrl_csr%ISOPEN THEN
7260: CLOSE l_hdrrl_csr;
7261: END IF;
7262:
7263: END check_residual_value;
7264:
7265: -- Start of comments
7266: --
7267: -- Procedure Name : check_product_status

Line 8469: IF ( l_lne.RESIDUAL_VALUE > l_OEC ) Then

8465: l_oec := l_lne.oec;
8466: end if;
8467:
8468: --Bug# 4631549
8469: IF ( l_lne.RESIDUAL_VALUE > l_OEC ) Then
8470: --IF ( l_lne.RESIDUAL_VALUE > l_lne.OEC ) THEN
8471: Okl_Api.set_message(
8472: p_app_name => G_APP_NAME,
8473: p_msg_name => 'OKL_QA_RES_GT_OEC',

Line 8470: --IF ( l_lne.RESIDUAL_VALUE > l_lne.OEC ) THEN

8466: end if;
8467:
8468: --Bug# 4631549
8469: IF ( l_lne.RESIDUAL_VALUE > l_OEC ) Then
8470: --IF ( l_lne.RESIDUAL_VALUE > l_lne.OEC ) THEN
8471: Okl_Api.set_message(
8472: p_app_name => G_APP_NAME,
8473: p_msg_name => 'OKL_QA_RES_GT_OEC',
8474: p_token1 => 'line',

Line 8502: IF (( UPPER(l_lne.residual_code) = 'NONE') AND (l_lne.residual_grnty_amount IS NOT NULL)) THEN

8498: p_token1_value => l_lne.name);
8499: x_return_status := Okl_Api.G_RET_STS_ERROR;
8500: END IF;
8501:
8502: IF (( UPPER(l_lne.residual_code) = 'NONE') AND (l_lne.residual_grnty_amount IS NOT NULL)) THEN
8503: Okl_Api.set_message(
8504: p_app_name => G_APP_NAME,
8505: p_msg_name => 'OKL_QA_NO_RESIDUAL_GRNTY',
8506: p_token1 => 'line',

Line 8505: p_msg_name => 'OKL_QA_NO_RESIDUAL_GRNTY',

8501:
8502: IF (( UPPER(l_lne.residual_code) = 'NONE') AND (l_lne.residual_grnty_amount IS NOT NULL)) THEN
8503: Okl_Api.set_message(
8504: p_app_name => G_APP_NAME,
8505: p_msg_name => 'OKL_QA_NO_RESIDUAL_GRNTY',
8506: p_token1 => 'line',
8507: p_token1_value => l_lne.name);
8508: x_return_status := Okl_Api.G_RET_STS_ERROR;
8509: END IF;

Line 8747: IF((l_lne.RESIDUAL_VALUE > 0)OR

8743: OPEN l_txl_csr(l_asst.fa_id);
8744: FETCH l_txl_csr INTO l_txl;
8745: CLOSE l_txl_csr;
8746:
8747: IF((l_lne.RESIDUAL_VALUE > 0)OR
8748: (l_txl.salvage_value > 0)OR
8749: (l_txl.percent_salvage_value > 0)) THEN
8750:
8751: Okl_Api.set_message(

Line 8796: If (( l_lne.residual_value < (0.2 l_lne.OEC)) AND (l_tax_owner = 'LESSOR')) then

8792: *CLOSE l_hdrrl_csr;
8793: */
8794:
8795: /*Bug#4186455
8796: *If (( l_lne.residual_value < (0.2 * l_lne.OEC)) AND (l_tax_owner = 'LESSOR')) then
8797: *--If (( l_lne.residual_value < (0.2 * l_lne.OEC)) AND (l_hdrrl_rec.RULE_INFORMATION1 = 'LESSOR')) then
8798: * OKL_API.set_message(
8799: * p_app_name => G_APP_NAME,
8800: * p_msg_name => 'OKL_QA_RV_OEC_TOWN',

Line 8797: --If (( l_lne.residual_value < (0.2 l_lne.OEC)) AND (l_hdrrl_rec.RULE_INFORMATION1 = 'LESSOR')) then

8793: */
8794:
8795: /*Bug#4186455
8796: *If (( l_lne.residual_value < (0.2 * l_lne.OEC)) AND (l_tax_owner = 'LESSOR')) then
8797: *--If (( l_lne.residual_value < (0.2 * l_lne.OEC)) AND (l_hdrrl_rec.RULE_INFORMATION1 = 'LESSOR')) then
8798: * OKL_API.set_message(
8799: * p_app_name => G_APP_NAME,
8800: * p_msg_name => 'OKL_QA_RV_OEC_TOWN',
8801: * p_token1 => 'line',

Line 9372: l_contract_residual_value NUMBER;

9368: l_hdrrl_rec l_hdrrl_csr%ROWTYPE;
9369: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
9370: l_tax_owner okc_rules_b.RULE_INFORMATION1%TYPE;
9371: l_purchase_opt_type okc_rules_b.RULE_INFORMATION11%TYPE;
9372: l_contract_residual_value NUMBER;
9373: l_msg_count NUMBER;
9374: l_msg_data VARCHAR2(2000);
9375:
9376: CURSOR l_asset_csr IS

Line 9379: kle.residual_value

9375:
9376: CURSOR l_asset_csr IS
9377: SELECT cle.id,
9378: name,
9379: kle.residual_value
9380: FROM okc_k_lines_v cle,
9381: okl_k_lines kle,
9382: okc_line_styles_b sty,
9383: okc_statuses_b sts

Line 9462: ,p_formula_name =>'CONTRACT_RESIDUAL_VALUE'

9458: ,p_init_msg_list => 'F'
9459: ,x_return_status =>l_return_status
9460: ,x_msg_count =>l_msg_count
9461: ,x_msg_data =>l_msg_data
9462: ,p_formula_name =>'CONTRACT_RESIDUAL_VALUE'
9463: ,p_contract_id =>p_chr_id
9464: ,x_value =>l_contract_residual_value);
9465:
9466: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

Line 9464: ,x_value =>l_contract_residual_value);

9460: ,x_msg_count =>l_msg_count
9461: ,x_msg_data =>l_msg_data
9462: ,p_formula_name =>'CONTRACT_RESIDUAL_VALUE'
9463: ,p_contract_id =>p_chr_id
9464: ,x_value =>l_contract_residual_value);
9465:
9466: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
9467: x_return_status := l_return_status;
9468: END IF;

Line 9473: IF (l_purchase_opt_type = '$1BO' AND l_asset_rec.residual_value> 1.0) THEN

9469: */
9470:
9471: FOR l_asset_rec IN l_asset_csr
9472: LOOP
9473: IF (l_purchase_opt_type = '$1BO' AND l_asset_rec.residual_value> 1.0) THEN
9474: Okl_Api.set_message(
9475: p_app_name => G_APP_NAME,
9476: p_msg_name => 'OKL_QA_CNTRCT_RES_VAL_GT1',
9477: p_token1 => 'ASSET_NUM',

Line 9610: FROM dual

9606: l_shipto_rec l_shipto_csr%ROWTYPE;
9607:
9608: CURSOR l_party_uses_csr ( instId NUMBER, ptyId NUMBER, rleCode VARCHAR2 ) IS
9609: SELECT 'Y' isThere
9610: FROM dual
9611: WHERE EXISTS(
9612: SELECT A.party_site_use_id
9613: FROM HZ_PARTY_SITE_USES A,
9614: HZ_PARTY_SITES B

Line 11272: kle.RESIDUAL_VALUE,

11268: CURSOR l_lne_pmnt_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
11269: SELECT kle.name,
11270: kle.CURRENCY_CODE,
11271: kle.id,
11272: kle.RESIDUAL_VALUE,
11273: kle.TRACKED_RESIDUAL,
11274: kle.CAPITAL_REDUCTION,
11275: kle.TRADEIN_AMOUNT,
11276: kle.RVI_PREMIUM,

Line 11273: kle.TRACKED_RESIDUAL,

11269: SELECT kle.name,
11270: kle.CURRENCY_CODE,
11271: kle.id,
11272: kle.RESIDUAL_VALUE,
11273: kle.TRACKED_RESIDUAL,
11274: kle.CAPITAL_REDUCTION,
11275: kle.TRADEIN_AMOUNT,
11276: kle.RVI_PREMIUM,
11277: kle.OEC,

Line 11278: kle.residual_code,

11274: kle.CAPITAL_REDUCTION,
11275: kle.TRADEIN_AMOUNT,
11276: kle.RVI_PREMIUM,
11277: kle.OEC,
11278: kle.residual_code,
11279: kle.residual_grnty_amount,
11280: kle.start_date,
11281: kle.end_date
11282: FROM OKL_K_LINES_FULL_V kle,

Line 11279: kle.residual_grnty_amount,

11275: kle.TRADEIN_AMOUNT,
11276: kle.RVI_PREMIUM,
11277: kle.OEC,
11278: kle.residual_code,
11279: kle.residual_grnty_amount,
11280: kle.start_date,
11281: kle.end_date
11282: FROM OKL_K_LINES_FULL_V kle,
11283: OKC_LINE_STYLES_B ls,