[Home] [Help]
66: tld_id NUMBER,
67: sel_id NUMBER,
68: xsi_id NUMBER,
69: xls_id NUMBER,
70: contract_number okc_k_headers_b.contract_number%TYPE,
71: stream_name okl_strm_type_v.name%TYPE,
72: bill_date DATE,
73: error_status VARCHAR2(10)
74: );
362: -- Changed CURSOR c_default_lead_days SQL definition
363: --Derive print lead days from receivables setup
364: CURSOR c_default_lead_days(p_khr_id IN NUMBER) IS
365: SELECT term.printing_lead_days
366: FROM okc_k_headers_b khr
367: ,hz_customer_profiles cp
368: ,ra_terms_b term
369: WHERE khr.id = p_khr_id
370: AND khr.bill_to_site_use_id = cp.site_use_id
449: SELECT okh.cust_acct_id,
450: hca.party_id
451: INTO p_cust_acct_id,
452: p_cust_party_id
453: FROM okc_k_headers_b okh,
454: hz_cust_accounts hca
455: WHERE hca.status = 'A'
456: AND okh.cust_acct_id = hca.cust_account_id
457: AND id = p_khr_id;
1015: SELECT MIN(ste.stream_element_date)
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
1300:
1301:
1302: -- For currecy precision rounded amount
1303: l_ste_amount OKL_STRM_ELEMENTS.amount%TYPE := 0;
1304: l_curr_code okc_k_headers_b.currency_code%TYPE;
1305:
1306: -------------------------------------------------------------------------
1307: -- Account Builder Code
1308: -------------------------------------------------------------------------
1314: sel_id NUMBER,
1315: tld_id NUMBER,
1316: xsi_id NUMBER,
1317: bill_date DATE,
1318: contract_number okc_k_headers_b.contract_number%TYPE,
1319: stream_name okl_strm_type_v.name%TYPE,
1320: amount OKL_STRM_ELEMENTS.amount%TYPE,
1321: error_message VARCHAR2(2000)
1322: );
1352: -- nikshah -- Bug # 5484903 Fixed,
1353: -- Changed CURSOR line_bill_to_csr SQL definition
1354: CURSOR line_bill_to_csr(p_khr_id NUMBER, p_kle_id NUMBER) IS
1355: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id
1356: FROM okc_k_headers_b khr
1357: , okx_cust_site_uses_v cs
1358: , okc_k_lines_b cle
1359: , hz_customer_profiles cp
1360: WHERE khr.id = p_khr_id
1364: AND cle.BILL_TO_SITE_USE_ID = cs.id1
1365: AND khr.bill_to_site_use_id = cp.site_use_id(+)
1366: UNION
1367: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id
1368: FROM okc_k_headers_b khr
1369: , okc_k_lines_b cle
1370: , okc_k_items item
1371: , okc_k_lines_b linked_asset
1372: , okx_cust_site_uses_v cs
1586:
1587: -- to get inventory_org_id bug 4890024 begin
1588: CURSOR inv_org_id_csr ( p_khr_id NUMBER ) IS
1589: SELECT nvl(inv_organization_id,-99)
1590: FROM okc_k_headers_b
1591: WHERE id = p_khr_id;
1592: -- bug 4890024 end
1593:
1594: -- modified by zrehman for Bug#6788005 on 07-Feb-2008 start
1601: -- get cust_acct_id and cust_acct_site_id for investor fees
1602: CURSOR get_inv_cust_info(p_khr_id NUMBER, p_kle_id NUMBER) IS
1603: SELECT cle_inv.cust_acct_id, cs.cust_acct_site_id, hz.party_name
1604: ,hz.party_id -- Added by Venkatho as part of Bug# 15959293
1605: FROM okc_k_headers_b khr
1606: , okx_cust_site_uses_v cs
1607: , okc_k_lines_b cle
1608: , okc_k_lines_b cle_inv
1609: , okc_k_party_roles_b cpl
2576: khr.sts_code sts_code
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
2629: khr.sts_code sts_code
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,
2677: khr.sts_code sts_code
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
2738: khr.sts_code sts_code
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
2801: khr.sts_code sts_code
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
2853: khr.sts_code sts_code
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,
2902: khr.sts_code sts_code
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
2962: khr.sts_code sts_code
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
3025: khr.sts_code sts_code
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,
3080: khr.sts_code sts_code
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,
3133: khr.sts_code sts_code
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,
3196: khr.sts_code sts_code
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,