APPS.OKL_INTERNAL_TO_EXTERNAL dependencies on OKL_EXT_SELL_INVS_V

Line 159: FROM okl_ext_sell_invs_v xsi,

155: j NUMBER := 0;
156:
157: CURSOR del_error_csr(p_xsi_id NUMBER) IS
158: SELECT xls.id xls_id
159: FROM okl_ext_sell_invs_v xsi,
160: okl_xtl_sell_invs_v xls
161: WHERE xls.xsi_id_details = xsi.id AND
162: xsi.id = p_xsi_id;
163:

Line 595: FROM okl_ext_sell_invs_v xsi,

591:
592: CURSOR del_xsi_3csr(p_tai_id NUMBER) IS
593: SELECT xsi.id xsi_id,
594: xls.id xls_id
595: FROM okl_ext_sell_invs_v xsi,
596: okl_xtl_sell_invs_v xls,
597: okl_trx_ar_invoices_v tai,
598: okl_txl_ar_inv_lns_v til,
599: okl_txd_ar_ln_dtls_v tld

Line 609: FROM okl_ext_sell_invs_v xsi,

605:
606: CURSOR del_xsi_2csr(p_tai_id NUMBER) IS
607: SELECT xsi.id xsi_id,
608: xls.id xls_id
609: FROM okl_ext_sell_invs_v xsi,
610: okl_xtl_sell_invs_v xls,
611: okl_trx_ar_invoices_v tai,
612: okl_txl_ar_inv_lns_v til
613: WHERE til.tai_id = tai.id

Line 867: FROM okl_ext_sell_invs_v

863: WHERE organization_id = nvl(to_number(substrb(userenv('CLIENT_INFO'), 1, 10)), -99);
864:
865: CURSOR xsi_cnt_succ_csr(p_req_id NUMBER, p_sts VARCHAR2) IS
866: SELECT COUNT(*)
867: FROM okl_ext_sell_invs_v
868: WHERE trx_status_code = p_sts
869: AND request_id = p_req_id;
870:
871: CURSOR xsi_cnt_err_csr(p_req_id NUMBER, p_sts VARCHAR2) IS

Line 873: FROM okl_ext_sell_invs_v

869: AND request_id = p_req_id;
870:
871: CURSOR xsi_cnt_err_csr(p_req_id NUMBER, p_sts VARCHAR2) IS
872: SELECT COUNT(*)
873: FROM okl_ext_sell_invs_v
874: WHERE trx_status_code = p_sts
875: AND request_id = p_req_id;
876:
877: l_succ_cnt NUMBER;

Line 886: submitted_sts okl_ext_sell_invs_v.trx_status_code%TYPE;

882:
883: -- ------------------------------------------------
884: -- Bind variables to address issues in bug 3761940
885: -- ------------------------------------------------
886: submitted_sts okl_ext_sell_invs_v.trx_status_code%TYPE;
887: error_sts okl_ext_sell_invs_v.trx_status_code%TYPE;
888: */
889: -- -------------------------------------------
890: -- To support new fields in XSI and XLS

Line 887: error_sts okl_ext_sell_invs_v.trx_status_code%TYPE;

883: -- ------------------------------------------------
884: -- Bind variables to address issues in bug 3761940
885: -- ------------------------------------------------
886: submitted_sts okl_ext_sell_invs_v.trx_status_code%TYPE;
887: error_sts okl_ext_sell_invs_v.trx_status_code%TYPE;
888: */
889: -- -------------------------------------------
890: -- To support new fields in XSI and XLS
891: -- Added on 21-MAR-2005

Line 3479: FROM okl_ext_sell_invs_v

3475:
3476:
3477: CURSOR xsi_cnt_succ_csr( p_req_id NUMBER, p_sts VARCHAR2 ) IS
3478: SELECT COUNT(*)
3479: FROM okl_ext_sell_invs_v
3480: WHERE trx_status_code = p_sts AND
3481: request_id = p_req_id ;
3482:
3483: ------------------------------------------------------------