APPS.OKL_AM_TERMNT_INTERFACE_PVT dependencies on OKC_K_LINES_V

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

823: CURSOR get_chr_dtls_csr(p_chr_no IN VARCHAR2) IS
824: SELECT id,sts_code,authoring_org_id
825: FROM okc_k_headers_b
826: WHERE contract_number=p_chr_no;
827: /* this cursor retrives the asset_id,asset_number,asset_status and description from okc_k_lines_v
828: and okc_line_styles_v with contract_id,asset_id,asset_number as input parameters.*/
829: CURSOR get_aset_dtls_csr(p_chr_id IN NUMBER,
830: p_ast_number IN VARCHAR2,
831: p_ast_id IN NUMBER) IS

Line 833: FROM okc_k_lines_v oklv, okc_line_styles_v ols

829: CURSOR get_aset_dtls_csr(p_chr_id IN NUMBER,
830: p_ast_number IN VARCHAR2,
831: p_ast_id IN NUMBER) IS
832: SELECT oklv.id id, oklv.name num, oklv.sts_code status, oklv.item_description description
833: FROM okc_k_lines_v oklv, okc_line_styles_v ols
834: WHERE oklv.chr_id= p_chr_id
835: AND ((oklv.name = p_ast_number)
836: OR (oklv.id = p_ast_id))
837: AND oklv.lse_id=ols.id

Line 843: FROM okc_k_lines_v oklv, okc_line_styles_v ols

839:
840: /* this cursor retrives the instance ids for the asset with asset_id as input parameter.*/
841: CURSOR get_instance_id_csr(p_ast_id IN NUMBER) IS
842: SELECT oklv.id id
843: FROM okc_k_lines_v oklv, okc_line_styles_v ols
844: WHERE oklv.cle_id = p_ast_id
845: AND oklv.lse_id=ols.id
846: AND ols.lty_code = 'FREE_FORM2';
847: /*this cursor is used to retrive the installbase id for an instance of the asset*/

Line 850: FROM okc_k_lines_v oklv, okc_line_styles_v ols

846: AND ols.lty_code = 'FREE_FORM2';
847: /*this cursor is used to retrive the installbase id for an instance of the asset*/
848: CURSOR get_installbase_id_csr(p_instance_id IN NUMBER) IS
849: SELECT oklv.id id
850: FROM okc_k_lines_v oklv, okc_line_styles_v ols
851: WHERE oklv.cle_id = p_instance_id
852: AND oklv.lse_id=ols.id
853: AND ols.lty_code = 'INST_ITEM';
854: /* this cursor retrives the serial_number for the instance of the asset*/

Line 1766: FROM okc_k_lines_v oklv, okc_line_styles_v ols

1762:
1763: /* this cursor retrives the instance ids for the asset with asset_id as input parameter.*/
1764: CURSOR get_instance_id_csr(p_ast_id IN NUMBER) IS
1765: SELECT oklv.id id
1766: FROM okc_k_lines_v oklv, okc_line_styles_v ols
1767: WHERE oklv.cle_id = p_ast_id
1768: AND oklv.lse_id=ols.id
1769: AND ols.lty_code = 'FREE_FORM2';
1770: /*this cursor is used to retrive the installbase id for an instance of the asset*/

Line 1773: FROM okc_k_lines_v oklv, okc_line_styles_v ols

1769: AND ols.lty_code = 'FREE_FORM2';
1770: /*this cursor is used to retrive the installbase id for an instance of the asset*/
1771: CURSOR get_installbase_id_csr(p_instance_id IN NUMBER) IS
1772: SELECT oklv.id id
1773: FROM okc_k_lines_v oklv, okc_line_styles_v ols
1774: WHERE oklv.cle_id = p_instance_id
1775: AND oklv.lse_id=ols.id
1776: AND ols.lty_code = 'INST_ITEM';
1777: /* this cursor retrives the serial_number and quantity for the instance of the asset*/