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 707: lv_lty_code OKC_LINE_STYLES_B.LTY_CODE%TYPE;

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

Line 718: okc_line_styles_b lse_ib,

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

Line 720: okc_line_styles_b lse_inst,

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

Line 722: okc_line_styles_b lse_fin,

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

Line 756: okc_line_styles_b lse

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

Line 3943: OKC_LINE_STYLES_B lse

3939: cle.name,
3940: cle.chr_id -- RMUNJULU 24-JAN-03 2759726 Added
3941: FROM OKL_TXL_QUOTE_LINES_B tql,
3942: OKC_K_LINES_V cle,
3943: OKC_LINE_STYLES_B lse
3944: WHERE tql.id = P_tql_id
3945: AND tql.qlt_code = 'AMCFIA'
3946: AND tql.kle_id = cle.id
3947: --AND cle.sts_code = 'BOOKED'

Line 3971: OKC_LINE_STYLES_B lse

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

Line 6031: OKC_LINE_STYLES_B LSE_IB,

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

Line 6033: OKC_LINE_STYLES_B LSE_INST,

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

Line 6035: OKC_LINE_STYLES_B LSE_FIN,

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

Line 6111: OKC_LINE_STYLES_B LSE_IB,

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

Line 6113: OKC_LINE_STYLES_B LSE_INST,

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

Line 6115: OKC_LINE_STYLES_B LSE_FIN,

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