APPS.OKL_AM_TERMNT_INTERFACE_PVT dependencies on OKC_K_LINES_V

Line 860: /* this cursor retrives the asset_id,asset_number,asset_status and description from okc_k_lines_v

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,
863: p_ast_number IN VARCHAR2,
864: p_ast_id IN NUMBER) IS

Line 866: FROM okc_k_lines_v oklv, okc_line_styles_v ols

862: CURSOR get_aset_dtls_csr(p_chr_id IN NUMBER,
863: p_ast_number IN VARCHAR2,
864: p_ast_id IN NUMBER) IS
865: SELECT oklv.id id, oklv.name num, oklv.sts_code status, oklv.item_description description
866: FROM okc_k_lines_v oklv, okc_line_styles_v ols
867: WHERE oklv.chr_id= p_chr_id
868: AND ((oklv.name = p_ast_number)
869: OR (oklv.id = p_ast_id))
870: AND oklv.lse_id=ols.id

Line 876: FROM okc_k_lines_v oklv, okc_line_styles_v ols

872:
873: /* this cursor retrives the instance ids for the asset with asset_id as input parameter.*/
874: CURSOR get_instance_id_csr(p_ast_id IN NUMBER) IS
875: SELECT oklv.id id
876: FROM okc_k_lines_v oklv, okc_line_styles_v ols
877: WHERE oklv.cle_id = p_ast_id
878: AND oklv.lse_id=ols.id
879: AND ols.lty_code = 'FREE_FORM2';
880: /*this cursor is used to retrive the installbase id for an instance of the asset*/

Line 883: FROM okc_k_lines_v oklv, okc_line_styles_v ols

879: AND ols.lty_code = 'FREE_FORM2';
880: /*this cursor is used to retrive the installbase id for an instance of the asset*/
881: CURSOR get_installbase_id_csr(p_instance_id IN NUMBER) IS
882: SELECT oklv.id id
883: FROM okc_k_lines_v oklv, okc_line_styles_v ols
884: WHERE oklv.cle_id = p_instance_id
885: AND oklv.lse_id=ols.id
886: AND ols.lty_code = 'INST_ITEM';
887: /* this cursor retrives the serial_number for the instance of the asset*/

Line 1934: FROM okc_k_lines_v oklv, okc_line_styles_v ols

1930:
1931: /* this cursor retrives the instance ids for the asset with asset_id as input parameter.*/
1932: CURSOR get_instance_id_csr(p_ast_id IN NUMBER) IS
1933: SELECT oklv.id id
1934: FROM okc_k_lines_v oklv, okc_line_styles_v ols
1935: WHERE oklv.cle_id = p_ast_id
1936: AND oklv.lse_id=ols.id
1937: AND ols.lty_code = 'FREE_FORM2';
1938: /*this cursor is used to retrive the installbase id for an instance of the asset*/

Line 1941: FROM okc_k_lines_v oklv, okc_line_styles_v ols

1937: AND ols.lty_code = 'FREE_FORM2';
1938: /*this cursor is used to retrive the installbase id for an instance of the asset*/
1939: CURSOR get_installbase_id_csr(p_instance_id IN NUMBER) IS
1940: SELECT oklv.id id
1941: FROM okc_k_lines_v oklv, okc_line_styles_v ols
1942: WHERE oklv.cle_id = p_instance_id
1943: AND oklv.lse_id=ols.id
1944: AND ols.lty_code = 'INST_ITEM';
1945: /* this cursor retrives the serial_number and quantity for the instance of the asset*/