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_LINE_STYLES_B

Line 718: lv_lty_code OKC_LINE_STYLES_B.LTY_CODE%TYPE;

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
722: -- RMUNJULU 24-JAN-03 2759726 Taken out the line status check

Line 729: okc_line_styles_b lse_ib,

725: SELECT csi.serial_number,
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,

Line 731: okc_line_styles_b lse_inst,

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,
735: okc_k_headers_b khr -- RMUNJULU 24-JAN-03 2759726 Added

Line 733: okc_line_styles_b lse_fin,

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
737: -- AND cle_fin.sts_code = 'BOOKED' -- RMUNJULU 24-JAN-03 2759726 Removed

Line 767: okc_line_styles_b lse

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
770: AND cle.dnz_chr_id = chr.id;
771: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_asset_sno';

Line 4153: OKC_LINE_STYLES_B lse

4149: cle.name,
4150: cle.chr_id -- RMUNJULU 24-JAN-03 2759726 Added
4151: FROM OKL_TXL_QUOTE_LINES_B tql,
4152: OKC_K_LINES_V cle,
4153: OKC_LINE_STYLES_B lse
4154: WHERE tql.id = P_tql_id
4155: AND tql.qlt_code = 'AMCFIA'
4156: AND tql.kle_id = cle.id
4157: --AND cle.sts_code = 'BOOKED'

Line 4181: OKC_LINE_STYLES_B lse

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
4185: AND lse.lty_code = 'INST_ITEM');

Line 6241: OKC_LINE_STYLES_B LSE_IB,

6237: HZ_PARTY_SITES HPS,
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,

Line 6243: OKC_LINE_STYLES_B LSE_INST,

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,
6247: OKL_TRX_QUOTES_B QTE,

Line 6245: OKC_LINE_STYLES_B LSE_FIN,

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,
6249: OKC_K_LINES_B CLE_FIN

Line 6321: OKC_LINE_STYLES_B LSE_IB,

6317: HZ_PARTY_SITES HPS,
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,

Line 6323: OKC_LINE_STYLES_B LSE_INST,

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,
6327: OKL_TRX_QUOTES_B QTE,

Line 6325: OKC_LINE_STYLES_B LSE_FIN,

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,
6329: OKC_K_LINES_B CLE_FIN,