[Home] [Help]
111: l_bank_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
112: l_rct_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;
113: l_asst_tax OKC_RULES_B.rule_information1%TYPE;
114: l_asst_line_tax OKC_RULES_B.rule_information1%TYPE;
115: l_product_id okl_k_headers_full_v.pdt_id%TYPE;
116:
117: -- Multi Currency Compliance
118: l_currency_code OKL_EXT_SELL_INVS_B.currency_code%TYPE;
119: l_currency_conversion_type OKL_EXT_SELL_INVS_B.currency_conversion_type%TYPE;
1016: FROM OKL_STRM_ELEMENTS ste,
1017: OKL_STREAMS stm,
1018: okl_strm_type_v sty,
1019: okc_k_headers_b khr,
1020: OKL_K_HEADERS khl,
1021: okc_k_lines_b kle,
1022: okc_statuses_b khs,
1023: okc_statuses_b kls
1024: WHERE ste.amount <> 0
1479: SELECT currency_code
1480: ,currency_conversion_type
1481: ,currency_conversion_rate
1482: ,currency_conversion_date
1483: FROM okl_k_headers_full_v
1484: WHERE id = cp_khr_id;
1485:
1486: -- nikshah -- Bug # 5484903 Fixed,
1487: -- Changed CURSOR std_terms_csr SQL definition
1495:
1496: --Get product Id
1497: CURSOR pdt_id_csr( p_khr_id NUMBER ) IS
1498: SELECT pdt_id
1499: FROM okl_k_headers_full_v
1500: WHERE id = p_khr_id;
1501: -- Variables for XTD Accounting Distributions
1502:
1503: l_esd_acc_cc_id OKL_AE_TMPT_LNES.code_combination_id%TYPE;
1531: l_turnoff_inv_on_bankruptcy VARCHAR2(1) := 'N';
1532: l_disposition_code iex_bankruptcies.disposition_code%TYPE;
1533: -- l_bankruptcy_flag VARCHAR2(1) := 'N'; --Commented by Venkatho as part of Bug# 14119181
1534: l_bankruptcy_flag VARCHAR2(1); --Added by Venkatho as part of Bug# 14119181
1535: l_previous_khr OKL_K_HEADERS.khr_id%TYPE;
1536:
1537: -- -------------------------------------------
1538: -- To support new fields in XSI and XLS
1539: -- -------------------------------------------
2577: FROM OKL_STRM_ELEMENTS ste,
2578: OKL_STREAMS stm,
2579: okl_strm_type_v sty,
2580: okc_k_headers_b khr,
2581: OKL_K_HEADERS khl,
2582: okc_k_lines_b kle,
2583: okc_statuses_b khs,
2584: okc_statuses_b kls
2585: WHERE TRUNC(ste.stream_element_date) >=
2630: FROM OKL_STRM_ELEMENTS ste,
2631: OKL_STREAMS stm,
2632: okl_strm_type_v sty,
2633: okc_k_headers_b khr,
2634: OKL_K_HEADERS khl,
2635: okc_k_lines_b kle,
2636: okc_statuses_b khs,
2637: okc_statuses_b kls,
2638: okc_k_lines_b cle
2678: FROM OKL_STRM_ELEMENTS ste,
2679: OKL_STREAMS stm,
2680: okl_strm_type_v sty,
2681: okc_k_headers_b khr,
2682: OKL_K_HEADERS khl,
2683: okc_k_lines_b kle,
2684: okc_statuses_b khs,
2685: okc_statuses_b kls
2686: WHERE TRUNC(ste.stream_element_date) >=
2739: FROM OKL_STRM_ELEMENTS ste,
2740: OKL_STREAMS stm,
2741: okl_strm_type_v sty,
2742: okc_k_headers_b khr,
2743: OKL_K_HEADERS khl,
2744: okc_k_lines_b kle,
2745: okc_statuses_b khs,
2746: okc_statuses_b kls
2747: WHERE TRUNC(ste.stream_element_date) >=
2802: FROM OKL_STRM_ELEMENTS ste,
2803: OKL_STREAMS stm,
2804: okl_strm_type_v sty,
2805: okc_k_headers_b khr,
2806: OKL_K_HEADERS khl,
2807: okc_k_lines_b kle,
2808: okc_statuses_b khs,
2809: okc_statuses_b kls
2810: WHERE TRUNC(ste.stream_element_date) >=
2854: FROM OKL_STRM_ELEMENTS ste,
2855: OKL_STREAMS stm,
2856: okl_strm_type_v sty,
2857: okc_k_headers_b khr,
2858: OKL_K_HEADERS khl,
2859: okc_k_lines_b kle,
2860: okc_statuses_b khs,
2861: okc_statuses_b kls,
2862: okc_k_lines_b cle
2903: FROM OKL_STRM_ELEMENTS ste,
2904: OKL_STREAMS stm,
2905: okl_strm_type_v sty,
2906: okc_k_headers_b khr,
2907: OKL_K_HEADERS khl,
2908: okc_k_lines_b kle,
2909: okc_statuses_b khs,
2910: okc_statuses_b kls
2911: WHERE TRUNC(ste.stream_element_date) >=
2963: FROM OKL_STRM_ELEMENTS ste,
2964: OKL_STREAMS stm,
2965: okl_strm_type_v sty,
2966: okc_k_headers_b khr,
2967: OKL_K_HEADERS khl,
2968: okc_k_lines_b kle,
2969: okc_statuses_b khs,
2970: okc_statuses_b kls
2971: WHERE TRUNC(ste.stream_element_date) >=
3026: FROM OKL_STRM_ELEMENTS ste,
3027: OKL_STREAMS stm,
3028: okl_strm_type_v sty,
3029: okc_k_headers_b khr,
3030: OKL_K_HEADERS khl,
3031: okc_k_lines_b kle,
3032: okc_statuses_b khs,
3033: okc_statuses_b kls,
3034: OKL_PARALLEL_PROCESSES pws
3081: FROM OKL_STRM_ELEMENTS ste,
3082: OKL_STREAMS stm,
3083: okl_strm_type_v sty,
3084: okc_k_headers_b khr,
3085: OKL_K_HEADERS khl,
3086: okc_k_lines_b kle,
3087: okc_statuses_b khs,
3088: okc_statuses_b kls,
3089: okc_k_lines_b cle,
3134: FROM OKL_STRM_ELEMENTS ste,
3135: OKL_STREAMS stm,
3136: okl_strm_type_v sty,
3137: okc_k_headers_b khr,
3138: OKL_K_HEADERS khl,
3139: okc_k_lines_b kle,
3140: okc_statuses_b khs,
3141: okc_statuses_b kls,
3142: OKL_PARALLEL_PROCESSES pws
3197: FROM OKL_STRM_ELEMENTS ste,
3198: OKL_STREAMS stm,
3199: okl_strm_type_v sty,
3200: okc_k_headers_b khr,
3201: OKL_K_HEADERS khl,
3202: okc_k_lines_b kle,
3203: okc_statuses_b khs,
3204: okc_statuses_b kls,
3205: OKL_PARALLEL_PROCESSES pws