[Home] [Help]
24:
25: CURSOR l_service_csr
26: IS
27: SELECT /*+ leading (kl) use_nl (kl ki) */ kl.ID cle_id
28: FROM okc_k_lines_b kl, okc_k_items ki, okc_statuses_b ks
29: WHERE kl.dnz_chr_id = p_chrid
30: AND kl.lse_id IN (1, 14, 19)
31: AND kl.ID = ki.cle_id
32: AND ki.object1_id1 = TO_CHAR (p_invserviceid)
202: IS
203: CURSOR l_ste_csr
204: IS
205: SELECT code
206: FROM okc_statuses_b
207: WHERE ste_code = p_ste_code AND default_yn = 'Y';
208:
209: CURSOR l_sts_csr
210: IS
208:
209: CURSOR l_sts_csr
210: IS
211: SELECT a.code, a.ste_code
212: FROM okc_statuses_b a, okc_statuses_b b
213: WHERE b.code = p_sts_code
214: AND b.ste_code = a.ste_code
215: AND a.default_yn = 'Y';
216:
1138: a.conversion_euro_rate, b.inv_trx_type, b.ar_interface_yn,
1139: b.summary_trx_yn, b.hold_billing, a.inv_organization_id,
1140: a.scs_code, c.ste_code source_ste_code, b.period_start,
1141: b.period_type, b.price_uom, a.billed_at_source
1142: FROM okc_k_headers_all_b a, oks_k_headers_b b, okc_statuses_b c
1143: WHERE a.ID = l_chr_id AND a.ID = b.chr_id AND p_sts_code = c.code;
1144:
1145: -- and c.ste_code in ('ACTIVE','ENTERED','SIGNED');
1146:
1170: l_billed_at_source VARCHAR2
1171: )
1172: IS
1173: SELECT a.ID
1174: FROM okc_k_headers_all_b a, oks_k_headers_b b, okc_statuses_b c
1175: WHERE a.ID = l_target_chr_id
1176: AND a.ID = b.chr_id
1177: AND a.sts_code= c.code --Bug fix 5614310
1178: AND c.ste_code IN ('ACTIVE', 'ENTERED', 'SIGNED')
1315: a.bill_to_site_use_id, a.line_renewal_type_code,
1316: b.tax_code --Fix for bug 4121175
1317: ,
1318: b.price_uom
1319: FROM okc_k_lines_b a, oks_k_lines_b b, okc_statuses_b c
1320: WHERE a.ID = l_line_id AND a.ID = b.cle_id AND a.sts_code = c.code;
1321:
1322: CURSOR service_item (l_line_id NUMBER)
1323: IS
1345: l_price_uom VARCHAR2
1346: )
1347: IS
1348: SELECT a.ID
1349: FROM okc_k_lines_b a, oks_k_lines_b b, okc_statuses_b c
1350: WHERE a.ID = l_line_id
1351: AND a.ID = b.cle_id
1352: AND a.sts_code = c.code
1353: AND c.ste_code IN ('ACTIVE', 'ENTERED', 'SIGNED')
2285: --status code
2286: CURSOR l_sts_csr (p_chr_id NUMBER)
2287: IS
2288: SELECT ste_code
2289: FROM okc_statuses_b, okc_k_headers_v kh
2290: WHERE code = kh.sts_code AND kh.ID = p_chr_id;
2291:
2292: --Check for vendor object_code
2293: CURSOR object_code_csr (p_code VARCHAR2)
3890: --enhancement to be commented
3891: CURSOR l_ste_csr (l_line_id NUMBER)
3892: IS
3893: SELECT os.ste_code
3894: FROM okc_statuses_b os, okc_k_lines_b ol
3895: WHERE ol.ID = l_line_id AND ol.sts_code = os.code;
3896:
3897: CURSOR l_salesgrp_csr (p_id NUMBER, p_start_date DATE, p_end_date DATE)
3898: IS
9516: CURSOR l_Launch_WF_csr (p_hdr_id NUMBER)
9517: IS
9518: SELECT 'Y'
9519: FROM okc_k_headers_b Kh, oks_k_headers_b Ks
9520: , okc_statuses_b sts
9521: WHERE Kh.ID = p_hdr_id
9522: And Ks.chr_id = Kh.id
9523: And kh.sts_code = sts.code
9524: And sts.ste_code = 'ENTERED'
9537:
9538: CURSOR l_toplines_csr (p_chr_id NUMBER, p_service_item_id NUMBER)
9539: IS
9540: SELECT kl.ID cle_id
9541: FROM okc_k_lines_b kl, okc_k_items ki, okc_statuses_b st
9542: WHERE kl.dnz_chr_id = p_chr_id
9543: AND kl.lse_id IN (1, 14, 19)
9544: AND kl.ID = ki.cle_id
9545: AND ki.object1_id1 = TO_CHAR (p_service_item_id)
10284:
10285: CURSOR l_hdr_sts_csr (p_hdr_id NUMBER)
10286: IS
10287: SELECT st.ste_code, kh.sts_code
10288: FROM okc_k_headers_b kh, okc_statuses_b st
10289: WHERE kh.ID = p_hdr_id AND st.code = kh.sts_code;
10290:
10291: -- Fix for bug 3588355
10292: CURSOR l_get_bill_ship_csr (p_cp_id NUMBER)
10551: */
10552: CURSOR l_line_sts_csr (p_line_id NUMBER)
10553: IS
10554: SELECT st.ste_code, kl.sts_code
10555: FROM okc_k_lines_b kl, okc_statuses_b st
10556: WHERE kl.ID = p_line_id AND st.code = kl.sts_code;
10557:
10558: CURSOR l_getprice_csr (p_line_id NUMBER)
10559: IS