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 717: lv_sts_code OKC_K_LINES_B.STS_CODE%TYPE;

713: G_CONTRACT_INACTIVE CONSTANT VARCHAR2(200) := 'OKL_AM_CONTRACT_INACTIVE';
714: lv_sno_yn VARCHAR2(3) := OKL_API.G_FALSE;
715: i NUMBER := 0;
716: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
717: lv_sts_code OKC_K_LINES_B.STS_CODE%TYPE;
718: lv_lty_code OKC_LINE_STYLES_B.LTY_CODE%TYPE;
719: lv_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
720:
721: -- Cursor to Know asset has serial number

Line 730: okc_k_lines_b cle_ib,

726: cle_ib.id
727: FROM csi_item_instances csi,
728: okc_k_items cim_ib,
729: okc_line_styles_b lse_ib,
730: okc_k_lines_b cle_ib,
731: okc_line_styles_b lse_inst,
732: okc_k_lines_b cle_inst,
733: okc_line_styles_b lse_fin,
734: okc_k_lines_b cle_fin,

Line 732: okc_k_lines_b cle_inst,

728: okc_k_items cim_ib,
729: okc_line_styles_b lse_ib,
730: okc_k_lines_b cle_ib,
731: okc_line_styles_b lse_inst,
732: okc_k_lines_b cle_inst,
733: okc_line_styles_b lse_fin,
734: okc_k_lines_b cle_fin,
735: okc_k_headers_b khr -- RMUNJULU 24-JAN-03 2759726 Added
736: WHERE cle_fin.cle_id is null

Line 734: okc_k_lines_b cle_fin,

730: okc_k_lines_b cle_ib,
731: okc_line_styles_b lse_inst,
732: okc_k_lines_b cle_inst,
733: okc_line_styles_b lse_fin,
734: okc_k_lines_b cle_fin,
735: okc_k_headers_b khr -- RMUNJULU 24-JAN-03 2759726 Added
736: WHERE cle_fin.cle_id is null
737: -- AND cle_fin.sts_code = 'BOOKED' -- RMUNJULU 24-JAN-03 2759726 Removed
738: AND cle_fin.chr_id = khr.id -- RMUNJULU 24-JAN-03 2759726 Added

Line 765: FROM okc_k_lines_b cle,

761: IS
762: SELECT lse.lty_code,
763: cle.sts_code,
764: chr.contract_number
765: FROM okc_k_lines_b cle,
766: okc_k_headers_b chr,
767: okc_line_styles_b lse
768: WHERE cle.id = p_asset_line
769: AND cle.lse_id = lse.id

Line 4130: ln_fin_line_id OKC_K_LINES_B.ID%TYPE;

4126: lv_sno_yn VARCHAR2(3);
4127: lv_select_yn VARCHAR2(3);
4128: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
4129: ln_select_count NUMBER := 0;
4130: ln_fin_line_id OKC_K_LINES_B.ID%TYPE;
4131:
4132: G_QUOTE_ALREADY_ACCP CONSTANT VARCHAR2(200) := 'OKL_AM_QUOTE_ALREADY_ACCP';
4133: G_INVALID_QUOTE_QTY CONSTANT VARCHAR2(200) := 'OKL_AM_INVALID_QUOTE_QTY';
4134: G_QTE_QTY_SRL_CNT_ERR CONSTANT VARCHAR2(200) := 'OKL_AM_QTE_QTY_SRL_CNT_ERR';

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

4161: AND lse.lse_parent_id IS NULL;
4162:
4163: -- Validate the contract id
4164: -- RMUNJULU 24-JAN-03 2759726 Taken out the sts_code check
4165: CURSOR validate_chr_id_csr(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
4166: SELECT 1
4167: FROM DUAL
4168: WHERE EXISTS (SELECT '1'
4169: FROM OKC_K_HEADERS_B chr

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

4171: AND scs_code = G_LEASE_SCS_CODE);
4172: --AND sts_code = 'BOOKED');
4173:
4174: -- Validate the Install Base line id and contract id
4175: CURSOR validate_Ib_line_csr(p_ib_id OKC_K_LINES_B.ID%TYPE,
4176: p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
4177: SELECT 1
4178: FROM DUAL
4179: WHERE EXISTS (SELECT '1'

Line 4176: p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS

4172: --AND sts_code = 'BOOKED');
4173:
4174: -- Validate the Install Base line id and contract id
4175: CURSOR validate_Ib_line_csr(p_ib_id OKC_K_LINES_B.ID%TYPE,
4176: p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
4177: SELECT 1
4178: FROM DUAL
4179: WHERE EXISTS (SELECT '1'
4180: FROM OKC_K_LINES_B cle,

Line 4180: FROM OKC_K_LINES_B cle,

4176: p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
4177: SELECT 1
4178: FROM DUAL
4179: WHERE EXISTS (SELECT '1'
4180: FROM OKC_K_LINES_B cle,
4181: OKC_LINE_STYLES_B lse
4182: WHERE cle.id = p_ib_id
4183: AND cle.dnz_chr_id = p_dnz_chr_id
4184: AND cle.lse_id = lse.id

Line 6242: OKC_K_LINES_B CLE_IB,

6238: HZ_PARTY_SITE_USES HPSU,
6239: CSI_ITEM_INSTANCES CSI,
6240: OKC_K_ITEMS CIM_IB,
6241: OKC_LINE_STYLES_B LSE_IB,
6242: OKC_K_LINES_B CLE_IB,
6243: OKC_LINE_STYLES_B LSE_INST,
6244: OKC_K_LINES_B CLE_INST,
6245: OKC_LINE_STYLES_B LSE_FIN,
6246: OKL_TXL_QUOTE_LINES_B TQL,

Line 6244: OKC_K_LINES_B CLE_INST,

6240: OKC_K_ITEMS CIM_IB,
6241: OKC_LINE_STYLES_B LSE_IB,
6242: OKC_K_LINES_B CLE_IB,
6243: OKC_LINE_STYLES_B LSE_INST,
6244: OKC_K_LINES_B CLE_INST,
6245: OKC_LINE_STYLES_B LSE_FIN,
6246: OKL_TXL_QUOTE_LINES_B TQL,
6247: OKL_TRX_QUOTES_B QTE,
6248: OKC_K_LINES_TL CLET_FIN,

Line 6249: OKC_K_LINES_B CLE_FIN

6245: OKC_LINE_STYLES_B LSE_FIN,
6246: OKL_TXL_QUOTE_LINES_B TQL,
6247: OKL_TRX_QUOTES_B QTE,
6248: OKC_K_LINES_TL CLET_FIN,
6249: OKC_K_LINES_B CLE_FIN
6250: WHERE CLE_FIN.CLE_ID IS NULL
6251: AND CLE_FIN.CHR_ID = CLE_FIN.DNZ_CHR_ID
6252: AND CLE_FIN.ID = CLET_FIN.ID
6253: AND CLET_FIN.LANGUAGE = USERENV('LANG')

Line 6322: OKC_K_LINES_B CLE_IB,

6318: HZ_PARTY_SITE_USES HPSU,
6319: CSI_ITEM_INSTANCES CSI,
6320: OKC_K_ITEMS CIM_IB,
6321: OKC_LINE_STYLES_B LSE_IB,
6322: OKC_K_LINES_B CLE_IB,
6323: OKC_LINE_STYLES_B LSE_INST,
6324: OKC_K_LINES_B CLE_INST,
6325: OKC_LINE_STYLES_B LSE_FIN,
6326: OKL_TXL_QUOTE_LINES_B TQL,

Line 6324: OKC_K_LINES_B CLE_INST,

6320: OKC_K_ITEMS CIM_IB,
6321: OKC_LINE_STYLES_B LSE_IB,
6322: OKC_K_LINES_B CLE_IB,
6323: OKC_LINE_STYLES_B LSE_INST,
6324: OKC_K_LINES_B CLE_INST,
6325: OKC_LINE_STYLES_B LSE_FIN,
6326: OKL_TXL_QUOTE_LINES_B TQL,
6327: OKL_TRX_QUOTES_B QTE,
6328: OKC_K_LINES_TL CLET_FIN,

Line 6329: OKC_K_LINES_B CLE_FIN,

6325: OKC_LINE_STYLES_B LSE_FIN,
6326: OKL_TXL_QUOTE_LINES_B TQL,
6327: OKL_TRX_QUOTES_B QTE,
6328: OKC_K_LINES_TL CLET_FIN,
6329: OKC_K_LINES_B CLE_FIN,
6330: OKL_TXD_QUOTE_LINE_DTLS TQD
6331: WHERE CLE_FIN.CLE_ID IS NULL
6332: AND CLE_FIN.CHR_ID = CLE_FIN.DNZ_CHR_ID
6333: AND CLE_FIN.ID = CLET_FIN.ID