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_AM_TERMNT_QUOTE_PVT dependencies on OKC_K_LINES_B

Line 706: lv_sts_code OKC_K_LINES_B.STS_CODE%TYPE;

702: G_CONTRACT_INACTIVE CONSTANT VARCHAR2(200) := 'OKL_AM_CONTRACT_INACTIVE';
703: lv_sno_yn VARCHAR2(3) := OKL_API.G_FALSE;
704: i NUMBER := 0;
705: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
706: lv_sts_code OKC_K_LINES_B.STS_CODE%TYPE;
707: lv_lty_code OKC_LINE_STYLES_B.LTY_CODE%TYPE;
708: lv_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
709:
710: -- Cursor to Know asset has serial number

Line 719: okc_k_lines_b cle_ib,

715: cle_ib.id
716: FROM csi_item_instances csi,
717: okc_k_items cim_ib,
718: okc_line_styles_b lse_ib,
719: okc_k_lines_b cle_ib,
720: okc_line_styles_b lse_inst,
721: okc_k_lines_b cle_inst,
722: okc_line_styles_b lse_fin,
723: okc_k_lines_b cle_fin,

Line 721: okc_k_lines_b cle_inst,

717: okc_k_items cim_ib,
718: okc_line_styles_b lse_ib,
719: okc_k_lines_b cle_ib,
720: okc_line_styles_b lse_inst,
721: okc_k_lines_b cle_inst,
722: okc_line_styles_b lse_fin,
723: okc_k_lines_b cle_fin,
724: okc_k_headers_b khr -- RMUNJULU 24-JAN-03 2759726 Added
725: WHERE cle_fin.cle_id is null

Line 723: okc_k_lines_b cle_fin,

719: okc_k_lines_b cle_ib,
720: okc_line_styles_b lse_inst,
721: okc_k_lines_b cle_inst,
722: okc_line_styles_b lse_fin,
723: okc_k_lines_b cle_fin,
724: okc_k_headers_b khr -- RMUNJULU 24-JAN-03 2759726 Added
725: WHERE cle_fin.cle_id is null
726: -- AND cle_fin.sts_code = 'BOOKED' -- RMUNJULU 24-JAN-03 2759726 Removed
727: AND cle_fin.chr_id = khr.id -- RMUNJULU 24-JAN-03 2759726 Added

Line 754: FROM okc_k_lines_b cle,

750: IS
751: SELECT lse.lty_code,
752: cle.sts_code,
753: chr.contract_number
754: FROM okc_k_lines_b cle,
755: okc_k_headers_b chr,
756: okc_line_styles_b lse
757: WHERE cle.id = p_asset_line
758: AND cle.lse_id = lse.id

Line 3920: ln_fin_line_id OKC_K_LINES_B.ID%TYPE;

3916: lv_sno_yn VARCHAR2(3);
3917: lv_select_yn VARCHAR2(3);
3918: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
3919: ln_select_count NUMBER := 0;
3920: ln_fin_line_id OKC_K_LINES_B.ID%TYPE;
3921:
3922: G_QUOTE_ALREADY_ACCP CONSTANT VARCHAR2(200) := 'OKL_AM_QUOTE_ALREADY_ACCP';
3923: G_INVALID_QUOTE_QTY CONSTANT VARCHAR2(200) := 'OKL_AM_INVALID_QUOTE_QTY';
3924: G_QTE_QTY_SRL_CNT_ERR CONSTANT VARCHAR2(200) := 'OKL_AM_QTE_QTY_SRL_CNT_ERR';

Line 3955: CURSOR validate_chr_id_csr(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS

3951: AND lse.lse_parent_id IS NULL;
3952:
3953: -- Validate the contract id
3954: -- RMUNJULU 24-JAN-03 2759726 Taken out the sts_code check
3955: CURSOR validate_chr_id_csr(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
3956: SELECT 1
3957: FROM DUAL
3958: WHERE EXISTS (SELECT '1'
3959: FROM OKC_K_HEADERS_B chr

Line 3965: CURSOR validate_Ib_line_csr(p_ib_id OKC_K_LINES_B.ID%TYPE,

3961: AND scs_code = G_LEASE_SCS_CODE);
3962: --AND sts_code = 'BOOKED');
3963:
3964: -- Validate the Install Base line id and contract id
3965: CURSOR validate_Ib_line_csr(p_ib_id OKC_K_LINES_B.ID%TYPE,
3966: p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
3967: SELECT 1
3968: FROM DUAL
3969: WHERE EXISTS (SELECT '1'

Line 3966: p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS

3962: --AND sts_code = 'BOOKED');
3963:
3964: -- Validate the Install Base line id and contract id
3965: CURSOR validate_Ib_line_csr(p_ib_id OKC_K_LINES_B.ID%TYPE,
3966: p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
3967: SELECT 1
3968: FROM DUAL
3969: WHERE EXISTS (SELECT '1'
3970: FROM OKC_K_LINES_B cle,

Line 3970: FROM OKC_K_LINES_B cle,

3966: p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
3967: SELECT 1
3968: FROM DUAL
3969: WHERE EXISTS (SELECT '1'
3970: FROM OKC_K_LINES_B cle,
3971: OKC_LINE_STYLES_B lse
3972: WHERE cle.id = p_ib_id
3973: AND cle.dnz_chr_id = p_dnz_chr_id
3974: AND cle.lse_id = lse.id

Line 6032: OKC_K_LINES_B CLE_IB,

6028: HZ_PARTY_SITE_USES HPSU,
6029: CSI_ITEM_INSTANCES CSI,
6030: OKC_K_ITEMS CIM_IB,
6031: OKC_LINE_STYLES_B LSE_IB,
6032: OKC_K_LINES_B CLE_IB,
6033: OKC_LINE_STYLES_B LSE_INST,
6034: OKC_K_LINES_B CLE_INST,
6035: OKC_LINE_STYLES_B LSE_FIN,
6036: OKL_TXL_QUOTE_LINES_B TQL,

Line 6034: OKC_K_LINES_B CLE_INST,

6030: OKC_K_ITEMS CIM_IB,
6031: OKC_LINE_STYLES_B LSE_IB,
6032: OKC_K_LINES_B CLE_IB,
6033: OKC_LINE_STYLES_B LSE_INST,
6034: OKC_K_LINES_B CLE_INST,
6035: OKC_LINE_STYLES_B LSE_FIN,
6036: OKL_TXL_QUOTE_LINES_B TQL,
6037: OKL_TRX_QUOTES_B QTE,
6038: OKC_K_LINES_TL CLET_FIN,

Line 6039: OKC_K_LINES_B CLE_FIN

6035: OKC_LINE_STYLES_B LSE_FIN,
6036: OKL_TXL_QUOTE_LINES_B TQL,
6037: OKL_TRX_QUOTES_B QTE,
6038: OKC_K_LINES_TL CLET_FIN,
6039: OKC_K_LINES_B CLE_FIN
6040: WHERE CLE_FIN.CLE_ID IS NULL
6041: AND CLE_FIN.CHR_ID = CLE_FIN.DNZ_CHR_ID
6042: AND CLE_FIN.ID = CLET_FIN.ID
6043: AND CLET_FIN.LANGUAGE = USERENV('LANG')

Line 6112: OKC_K_LINES_B CLE_IB,

6108: HZ_PARTY_SITE_USES HPSU,
6109: CSI_ITEM_INSTANCES CSI,
6110: OKC_K_ITEMS CIM_IB,
6111: OKC_LINE_STYLES_B LSE_IB,
6112: OKC_K_LINES_B CLE_IB,
6113: OKC_LINE_STYLES_B LSE_INST,
6114: OKC_K_LINES_B CLE_INST,
6115: OKC_LINE_STYLES_B LSE_FIN,
6116: OKL_TXL_QUOTE_LINES_B TQL,

Line 6114: OKC_K_LINES_B CLE_INST,

6110: OKC_K_ITEMS CIM_IB,
6111: OKC_LINE_STYLES_B LSE_IB,
6112: OKC_K_LINES_B CLE_IB,
6113: OKC_LINE_STYLES_B LSE_INST,
6114: OKC_K_LINES_B CLE_INST,
6115: OKC_LINE_STYLES_B LSE_FIN,
6116: OKL_TXL_QUOTE_LINES_B TQL,
6117: OKL_TRX_QUOTES_B QTE,
6118: OKC_K_LINES_TL CLET_FIN,

Line 6119: OKC_K_LINES_B CLE_FIN,

6115: OKC_LINE_STYLES_B LSE_FIN,
6116: OKL_TXL_QUOTE_LINES_B TQL,
6117: OKL_TRX_QUOTES_B QTE,
6118: OKC_K_LINES_TL CLET_FIN,
6119: OKC_K_LINES_B CLE_FIN,
6120: OKL_TXD_QUOTE_LINE_DTLS TQD
6121: WHERE CLE_FIN.CLE_ID IS NULL
6122: AND CLE_FIN.CHR_ID = CLE_FIN.DNZ_CHR_ID
6123: AND CLE_FIN.ID = CLET_FIN.ID