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_INTERFACE_PVT dependencies on OKC_K_HEADERS_B

Line 840: l_contract_status OKC_K_HEADERS_B.sts_code%TYPE;

836: ) IS
837:
838: l_serial_number OKL_TERMNT_INTERFACE.serial_number%TYPE;
839: l_contract_id OKL_TERMNT_INTERFACE.contract_id%TYPE;
840: l_contract_status OKC_K_HEADERS_B.sts_code%TYPE;
841: l_asset_number OKL_TERMNT_INTERFACE.asset_number%TYPE;
842: l_asset_id OKL_TERMNT_INTERFACE.asset_id%TYPE;
843: l_asset_description OKL_TERMNT_INTERFACE.asset_description%TYPE;
844: l_asset_status OKL_K_LINES_FULL_V.sts_code%TYPE;

Line 854: /*this cursor retrives the contract_id and status from OKC_K_HEADERS_B with contract number

850: l_session_org_id NUMBER := MO_GLOBAL.GET_CURRENT_ORG_ID();
851: l_count_asset NUMBER := 0;
852: message VARCHAR2(200);
853: l_msg_tbl msg_tbl_type;
854: /*this cursor retrives the contract_id and status from OKC_K_HEADERS_B with contract number
855: as input parameter*/
856: CURSOR get_chr_dtls_csr(p_chr_no IN VARCHAR2) IS
857: SELECT id,sts_code,authoring_org_id
858: FROM okc_k_headers_b

Line 858: FROM okc_k_headers_b

854: /*this cursor retrives the contract_id and status from OKC_K_HEADERS_B with contract number
855: as input parameter*/
856: CURSOR get_chr_dtls_csr(p_chr_no IN VARCHAR2) IS
857: SELECT id,sts_code,authoring_org_id
858: FROM okc_k_headers_b
859: WHERE contract_number=p_chr_no;
860: /* this cursor retrives the asset_id,asset_number,asset_status and description from okc_k_lines_v
861: and okc_line_styles_v with contract_id,asset_id,asset_number as input parameters.*/
862: CURSOR get_aset_dtls_csr(p_chr_id IN NUMBER,