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 327: FROM DUAL

323: --Bug# 4928841 :Modified cursor definition
324: /*
325: CURSOR inactive_assets_csr(chrId IN NUMBER) IS
326: SELECT 'Y'
327: FROM DUAL
328: WHERE EXISTS
329: (
330: SELECT 'Y'
331: FROM OKC_K_ITEMS fa_cim,

Line 384: FROM DUAL

380: ) ); */
381:
382: CURSOR inactive_assets_csr(chrId IN NUMBER) IS
383: SELECT 'Y'
384: FROM DUAL
385: WHERE EXISTS
386: (
387: SELECT 1
388: FROM OKC_K_LINES_B fa_cle,

Line 4745: *FROM dual;

4741:
4742: /*
4743: *CURSOR strm_profile_csr IS
4744: *SELECT fnd_profile.VALUE('OKL_STREAMS_GEN_PATH')
4745: *FROM dual;
4746: */
4747:
4748: l_strm_profile VARCHAR2(50);
4749: lx_return_status VARCHAR2(1);

Line 6799: -- Procedure Name : check_residual_value

6795: END check_stream_template;
6796:
6797: -- Start of comments
6798: --
6799: -- Procedure Name : check_residual_value
6800: -- Description : Bug#4186455
6801: -- : Throws a message if asset residual value is less than 20%
6802: -- : and tax owner for the contract is LESSOR. The message
6803: -- : is conifgurable to error or warning.

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

6797: -- Start of comments
6798: --
6799: -- Procedure Name : check_residual_value
6800: -- Description : Bug#4186455
6801: -- : Throws a message if asset residual value is less than 20%
6802: -- : and tax owner for the contract is LESSOR. The message
6803: -- : is conifgurable to error or warning.
6804: -- Business Rules :
6805: -- Parameters :

Line 6809: PROCEDURE check_residual_value(

6805: -- Parameters :
6806: -- Version : 1.0
6807: -- End of comments
6808:
6809: PROCEDURE check_residual_value(
6810: x_return_status OUT NOCOPY VARCHAR2,
6811: p_chr_id IN NUMBER
6812: ) IS
6813:

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

6839: l_oec := l_lne.oec;
6840: end if;
6841:
6842: --Bug# 4631549
6843: IF (( nvl(l_lne.residual_value,0) < (0.2 * l_OEC)) AND (l_tax_owner = 'LESSOR')) THEN
6844: --IF (( NVL(l_lne.residual_value,0) < (0.2 * l_lne.OEC)) AND (l_tax_owner = 'LESSOR')) THEN
6845: Okl_Api.set_message(
6846: p_app_name => G_APP_NAME,
6847: p_msg_name => 'OKL_QA_RV_OEC_TOWN',

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

6840: end if;
6841:
6842: --Bug# 4631549
6843: IF (( nvl(l_lne.residual_value,0) < (0.2 * l_OEC)) AND (l_tax_owner = 'LESSOR')) THEN
6844: --IF (( NVL(l_lne.residual_value,0) < (0.2 * l_lne.OEC)) AND (l_tax_owner = 'LESSOR')) THEN
6845: Okl_Api.set_message(
6846: p_app_name => G_APP_NAME,
6847: p_msg_name => 'OKL_QA_RV_OEC_TOWN',
6848: p_token1 => 'line',

Line 6876: END check_residual_value;

6872: IF l_hdrrl_csr%ISOPEN THEN
6873: CLOSE l_hdrrl_csr;
6874: END IF;
6875:
6876: END check_residual_value;
6877:
6878: -- Start of comments
6879: --
6880: -- Procedure Name : check_product_status

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

8048: l_oec := l_lne.oec;
8049: end if;
8050:
8051: --Bug# 4631549
8052: IF ( l_lne.RESIDUAL_VALUE > l_OEC ) Then
8053: --IF ( l_lne.RESIDUAL_VALUE > l_lne.OEC ) THEN
8054: Okl_Api.set_message(
8055: p_app_name => G_APP_NAME,
8056: p_msg_name => 'OKL_QA_RES_GT_OEC',

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

8049: end if;
8050:
8051: --Bug# 4631549
8052: IF ( l_lne.RESIDUAL_VALUE > l_OEC ) Then
8053: --IF ( l_lne.RESIDUAL_VALUE > l_lne.OEC ) THEN
8054: Okl_Api.set_message(
8055: p_app_name => G_APP_NAME,
8056: p_msg_name => 'OKL_QA_RES_GT_OEC',
8057: p_token1 => 'line',

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

8081: p_token1_value => l_lne.name);
8082: x_return_status := Okl_Api.G_RET_STS_ERROR;
8083: END IF;
8084:
8085: IF (( UPPER(l_lne.residual_code) = 'NONE') AND (l_lne.residual_grnty_amount IS NOT NULL)) THEN
8086: Okl_Api.set_message(
8087: p_app_name => G_APP_NAME,
8088: p_msg_name => 'OKL_QA_NO_RESIDUAL_GRNTY',
8089: p_token1 => 'line',

Line 8088: p_msg_name => 'OKL_QA_NO_RESIDUAL_GRNTY',

8084:
8085: IF (( UPPER(l_lne.residual_code) = 'NONE') AND (l_lne.residual_grnty_amount IS NOT NULL)) THEN
8086: Okl_Api.set_message(
8087: p_app_name => G_APP_NAME,
8088: p_msg_name => 'OKL_QA_NO_RESIDUAL_GRNTY',
8089: p_token1 => 'line',
8090: p_token1_value => l_lne.name);
8091: x_return_status := Okl_Api.G_RET_STS_ERROR;
8092: END IF;

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

8326: OPEN l_txl_csr(l_asst.fa_id);
8327: FETCH l_txl_csr INTO l_txl;
8328: CLOSE l_txl_csr;
8329:
8330: IF((l_lne.RESIDUAL_VALUE > 0)OR
8331: (l_txl.salvage_value > 0)OR
8332: (l_txl.percent_salvage_value > 0)) THEN
8333:
8334: Okl_Api.set_message(

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

8375: *CLOSE l_hdrrl_csr;
8376: */
8377:
8378: /*Bug#4186455
8379: *If (( l_lne.residual_value < (0.2 * l_lne.OEC)) AND (l_tax_owner = 'LESSOR')) then
8380: *--If (( l_lne.residual_value < (0.2 * l_lne.OEC)) AND (l_hdrrl_rec.RULE_INFORMATION1 = 'LESSOR')) then
8381: * OKL_API.set_message(
8382: * p_app_name => G_APP_NAME,
8383: * p_msg_name => 'OKL_QA_RV_OEC_TOWN',

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

8376: */
8377:
8378: /*Bug#4186455
8379: *If (( l_lne.residual_value < (0.2 * l_lne.OEC)) AND (l_tax_owner = 'LESSOR')) then
8380: *--If (( l_lne.residual_value < (0.2 * l_lne.OEC)) AND (l_hdrrl_rec.RULE_INFORMATION1 = 'LESSOR')) then
8381: * OKL_API.set_message(
8382: * p_app_name => G_APP_NAME,
8383: * p_msg_name => 'OKL_QA_RV_OEC_TOWN',
8384: * p_token1 => 'line',

Line 8951: l_contract_residual_value NUMBER;

8947: l_hdrrl_rec l_hdrrl_csr%ROWTYPE;
8948: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
8949: l_tax_owner okc_rules_b.RULE_INFORMATION1%TYPE;
8950: l_purchase_opt_type okc_rules_b.RULE_INFORMATION11%TYPE;
8951: l_contract_residual_value NUMBER;
8952: l_msg_count NUMBER;
8953: l_msg_data VARCHAR2(2000);
8954:
8955: CURSOR l_asset_csr IS

Line 8958: kle.residual_value

8954:
8955: CURSOR l_asset_csr IS
8956: SELECT cle.id,
8957: name,
8958: kle.residual_value
8959: FROM okc_k_lines_v cle,
8960: okl_k_lines kle,
8961: okc_line_styles_b sty,
8962: okc_statuses_b sts

Line 9041: ,p_formula_name =>'CONTRACT_RESIDUAL_VALUE'

9037: ,p_init_msg_list => 'F'
9038: ,x_return_status =>l_return_status
9039: ,x_msg_count =>l_msg_count
9040: ,x_msg_data =>l_msg_data
9041: ,p_formula_name =>'CONTRACT_RESIDUAL_VALUE'
9042: ,p_contract_id =>p_chr_id
9043: ,x_value =>l_contract_residual_value);
9044:
9045: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

Line 9043: ,x_value =>l_contract_residual_value);

9039: ,x_msg_count =>l_msg_count
9040: ,x_msg_data =>l_msg_data
9041: ,p_formula_name =>'CONTRACT_RESIDUAL_VALUE'
9042: ,p_contract_id =>p_chr_id
9043: ,x_value =>l_contract_residual_value);
9044:
9045: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
9046: x_return_status := l_return_status;
9047: END IF;

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

9048: */
9049:
9050: FOR l_asset_rec IN l_asset_csr
9051: LOOP
9052: IF (l_purchase_opt_type = '$1BO' AND l_asset_rec.residual_value> 1.0) THEN
9053: Okl_Api.set_message(
9054: p_app_name => G_APP_NAME,
9055: p_msg_name => 'OKL_QA_CNTRCT_RES_VAL_GT1',
9056: p_token1 => 'ASSET_NUM',

Line 9189: FROM dual

9185: l_shipto_rec l_shipto_csr%ROWTYPE;
9186:
9187: CURSOR l_party_uses_csr ( instId NUMBER, ptyId NUMBER, rleCode VARCHAR2 ) IS
9188: SELECT 'Y' isThere
9189: FROM dual
9190: WHERE EXISTS(
9191: SELECT A.party_site_use_id
9192: FROM HZ_PARTY_SITE_USES A,
9193: HZ_PARTY_SITES B

Line 10849: kle.RESIDUAL_VALUE,

10845: CURSOR l_lne_pmnt_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
10846: SELECT kle.name,
10847: kle.CURRENCY_CODE,
10848: kle.id,
10849: kle.RESIDUAL_VALUE,
10850: kle.TRACKED_RESIDUAL,
10851: kle.CAPITAL_REDUCTION,
10852: kle.TRADEIN_AMOUNT,
10853: kle.RVI_PREMIUM,

Line 10850: kle.TRACKED_RESIDUAL,

10846: SELECT kle.name,
10847: kle.CURRENCY_CODE,
10848: kle.id,
10849: kle.RESIDUAL_VALUE,
10850: kle.TRACKED_RESIDUAL,
10851: kle.CAPITAL_REDUCTION,
10852: kle.TRADEIN_AMOUNT,
10853: kle.RVI_PREMIUM,
10854: kle.OEC,

Line 10855: kle.residual_code,

10851: kle.CAPITAL_REDUCTION,
10852: kle.TRADEIN_AMOUNT,
10853: kle.RVI_PREMIUM,
10854: kle.OEC,
10855: kle.residual_code,
10856: kle.residual_grnty_amount,
10857: kle.start_date,
10858: kle.end_date
10859: FROM OKL_K_LINES_FULL_V kle,

Line 10856: kle.residual_grnty_amount,

10852: kle.TRADEIN_AMOUNT,
10853: kle.RVI_PREMIUM,
10854: kle.OEC,
10855: kle.residual_code,
10856: kle.residual_grnty_amount,
10857: kle.start_date,
10858: kle.end_date
10859: FROM OKL_K_LINES_FULL_V kle,
10860: OKC_LINE_STYLES_B ls,