[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: );
360: -- Changed CURSOR c_default_lead_days SQL definition
361: --Derive print lead days from receivables setup
362: CURSOR c_default_lead_days(p_khr_id IN NUMBER) IS
363: SELECT term.printing_lead_days
364: FROM okc_k_headers_b khr
365: ,hz_customer_profiles cp
366: ,ra_terms_b term
367: WHERE khr.id = p_khr_id
368: AND khr.bill_to_site_use_id = cp.site_use_id
953: SELECT MIN(ste.stream_element_date)
954: FROM OKL_STRM_ELEMENTS ste,
955: OKL_STREAMS stm,
956: okl_strm_type_v sty,
957: okc_k_headers_b khr,
958: OKL_K_HEADERS khl,
959: okc_k_lines_b kle,
960: okc_statuses_b khs,
961: okc_statuses_b kls
1238:
1239:
1240: -- For currecy precision rounded amount
1241: l_ste_amount OKL_STRM_ELEMENTS.amount%TYPE := 0;
1242: l_curr_code okc_k_headers_b.currency_code%TYPE;
1243:
1244: -------------------------------------------------------------------------
1245: -- Account Builder Code
1246: -------------------------------------------------------------------------
1252: sel_id NUMBER,
1253: tld_id NUMBER,
1254: xsi_id NUMBER,
1255: bill_date DATE,
1256: contract_number okc_k_headers_b.contract_number%TYPE,
1257: stream_name okl_strm_type_v.name%TYPE,
1258: amount OKL_STRM_ELEMENTS.amount%TYPE,
1259: error_message VARCHAR2(2000)
1260: );
1290: -- nikshah -- Bug # 5484903 Fixed,
1291: -- Changed CURSOR line_bill_to_csr SQL definition
1292: CURSOR line_bill_to_csr(p_khr_id NUMBER, p_kle_id NUMBER) IS
1293: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id
1294: FROM okc_k_headers_b khr
1295: , okx_cust_site_uses_v cs
1296: , okc_k_lines_b cle
1297: , hz_customer_profiles cp
1298: WHERE khr.id = p_khr_id
1302: AND cle.BILL_TO_SITE_USE_ID = cs.id1
1303: AND khr.bill_to_site_use_id = cp.site_use_id(+)
1304: UNION
1305: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id
1306: FROM okc_k_headers_b khr
1307: , okc_k_lines_b cle
1308: , okc_k_items item
1309: , okc_k_lines_b linked_asset
1310: , okx_cust_site_uses_v cs
1523:
1524: -- to get inventory_org_id bug 4890024 begin
1525: CURSOR inv_org_id_csr ( p_khr_id NUMBER ) IS
1526: SELECT nvl(inv_organization_id,-99)
1527: FROM okc_k_headers_b
1528: WHERE id = p_khr_id;
1529: -- bug 4890024 end
1530:
1531: -- modified by zrehman for Bug#6788005 on 07-Feb-2008 start
1537: l_is_inv NUMBER := 0;
1538: -- get cust_acct_id and cust_acct_site_id for investor fees
1539: CURSOR get_inv_cust_info(p_khr_id NUMBER, p_kle_id NUMBER) IS
1540: SELECT cle_inv.cust_acct_id, cs.cust_acct_site_id, hz.party_name
1541: FROM okc_k_headers_b khr
1542: , okx_cust_site_uses_v cs
1543: , okc_k_lines_b cle
1544: , okc_k_lines_b cle_inv
1545: , okc_k_party_roles_b cpl
2392: khr.sts_code sts_code
2393: FROM OKL_STRM_ELEMENTS ste,
2394: OKL_STREAMS stm,
2395: okl_strm_type_v sty,
2396: okc_k_headers_b khr,
2397: OKL_K_HEADERS khl,
2398: okc_k_lines_b kle,
2399: okc_statuses_b khs,
2400: okc_statuses_b kls
2445: khr.sts_code sts_code
2446: FROM OKL_STRM_ELEMENTS ste,
2447: OKL_STREAMS stm,
2448: okl_strm_type_v sty,
2449: okc_k_headers_b khr,
2450: OKL_K_HEADERS khl,
2451: okc_k_lines_b kle,
2452: okc_statuses_b khs,
2453: okc_statuses_b kls,
2493: khr.sts_code sts_code
2494: FROM OKL_STRM_ELEMENTS ste,
2495: OKL_STREAMS stm,
2496: okl_strm_type_v sty,
2497: okc_k_headers_b khr,
2498: OKL_K_HEADERS khl,
2499: okc_k_lines_b kle,
2500: okc_statuses_b khs,
2501: okc_statuses_b kls
2554: khr.sts_code sts_code
2555: FROM OKL_STRM_ELEMENTS ste,
2556: OKL_STREAMS stm,
2557: okl_strm_type_v sty,
2558: okc_k_headers_b khr,
2559: OKL_K_HEADERS khl,
2560: okc_k_lines_b kle,
2561: okc_statuses_b khs,
2562: okc_statuses_b kls
2614: khr.sts_code sts_code
2615: FROM OKL_STRM_ELEMENTS ste,
2616: OKL_STREAMS stm,
2617: okl_strm_type_v sty,
2618: okc_k_headers_b khr,
2619: OKL_K_HEADERS khl,
2620: okc_k_lines_b kle,
2621: okc_statuses_b khs,
2622: okc_statuses_b kls
2666: khr.sts_code sts_code
2667: FROM OKL_STRM_ELEMENTS ste,
2668: OKL_STREAMS stm,
2669: okl_strm_type_v sty,
2670: okc_k_headers_b khr,
2671: OKL_K_HEADERS khl,
2672: okc_k_lines_b kle,
2673: okc_statuses_b khs,
2674: okc_statuses_b kls,
2715: khr.sts_code sts_code
2716: FROM OKL_STRM_ELEMENTS ste,
2717: OKL_STREAMS stm,
2718: okl_strm_type_v sty,
2719: okc_k_headers_b khr,
2720: OKL_K_HEADERS khl,
2721: okc_k_lines_b kle,
2722: okc_statuses_b khs,
2723: okc_statuses_b kls
2775: khr.sts_code sts_code
2776: FROM OKL_STRM_ELEMENTS ste,
2777: OKL_STREAMS stm,
2778: okl_strm_type_v sty,
2779: okc_k_headers_b khr,
2780: OKL_K_HEADERS khl,
2781: okc_k_lines_b kle,
2782: okc_statuses_b khs,
2783: okc_statuses_b kls
2835: khr.sts_code sts_code
2836: FROM OKL_STRM_ELEMENTS ste,
2837: OKL_STREAMS stm,
2838: okl_strm_type_v sty,
2839: okc_k_headers_b khr,
2840: OKL_K_HEADERS khl,
2841: okc_k_lines_b kle,
2842: okc_statuses_b khs,
2843: okc_statuses_b kls,
2890: khr.sts_code sts_code
2891: FROM OKL_STRM_ELEMENTS ste,
2892: OKL_STREAMS stm,
2893: okl_strm_type_v sty,
2894: okc_k_headers_b khr,
2895: OKL_K_HEADERS khl,
2896: okc_k_lines_b kle,
2897: okc_statuses_b khs,
2898: okc_statuses_b kls,
2943: khr.sts_code sts_code
2944: FROM OKL_STRM_ELEMENTS ste,
2945: OKL_STREAMS stm,
2946: okl_strm_type_v sty,
2947: okc_k_headers_b khr,
2948: OKL_K_HEADERS khl,
2949: okc_k_lines_b kle,
2950: okc_statuses_b khs,
2951: okc_statuses_b kls,
3006: khr.sts_code sts_code
3007: FROM OKL_STRM_ELEMENTS ste,
3008: OKL_STREAMS stm,
3009: okl_strm_type_v sty,
3010: okc_k_headers_b khr,
3011: OKL_K_HEADERS khl,
3012: okc_k_lines_b kle,
3013: okc_statuses_b khs,
3014: okc_statuses_b kls,