[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)
162: IS
163: CURSOR l_ste_csr
164: IS
165: SELECT code
166: FROM okc_statuses_b
167: WHERE ste_code = p_ste_code AND default_yn = 'Y';
168:
169: CURSOR l_sts_csr
170: IS
168:
169: CURSOR l_sts_csr
170: IS
171: SELECT a.code, a.ste_code
172: FROM okc_statuses_b a, okc_statuses_b b
173: WHERE b.code = p_sts_code
174: AND b.ste_code = a.ste_code
175: AND a.default_yn = 'Y';
176:
1098: a.conversion_euro_rate, b.inv_trx_type, b.ar_interface_yn,
1099: b.summary_trx_yn, b.hold_billing, a.inv_organization_id,
1100: a.scs_code, c.ste_code source_ste_code, b.period_start,
1101: b.period_type, b.price_uom, a.billed_at_source
1102: FROM okc_k_headers_all_b a, oks_k_headers_b b, okc_statuses_b c
1103: WHERE a.ID = l_chr_id AND a.ID = b.chr_id AND p_sts_code = c.code;
1104:
1105: -- and c.ste_code in ('ACTIVE','ENTERED','SIGNED');
1106:
1130: l_billed_at_source VARCHAR2
1131: )
1132: IS
1133: SELECT a.ID
1134: FROM okc_k_headers_all_b a, oks_k_headers_b b, okc_statuses_b c
1135: WHERE a.ID = l_target_chr_id
1136: AND a.ID = b.chr_id
1137: AND a.sts_code= c.code --Bug fix 5614310
1138: AND c.ste_code IN ('ACTIVE', 'ENTERED', 'SIGNED')
1275: a.bill_to_site_use_id, a.line_renewal_type_code,
1276: b.tax_code --Fix for bug 4121175
1277: ,
1278: b.price_uom
1279: FROM okc_k_lines_b a, oks_k_lines_b b, okc_statuses_b c
1280: WHERE a.ID = l_line_id AND a.ID = b.cle_id AND a.sts_code = c.code;
1281:
1282: CURSOR service_item (l_line_id NUMBER)
1283: IS
1305: l_price_uom VARCHAR2
1306: )
1307: IS
1308: SELECT a.ID
1309: FROM okc_k_lines_b a, oks_k_lines_b b, okc_statuses_b c
1310: WHERE a.ID = l_line_id
1311: AND a.ID = b.cle_id
1312: AND a.sts_code = c.code
1313: AND c.ste_code IN ('ACTIVE', 'ENTERED', 'SIGNED')
2245: --status code
2246: CURSOR l_sts_csr (p_chr_id NUMBER)
2247: IS
2248: SELECT ste_code
2249: FROM okc_statuses_b, okc_k_headers_v kh
2250: WHERE code = kh.sts_code AND kh.ID = p_chr_id;
2251:
2252: --Check for vendor object_code
2253: CURSOR object_code_csr (p_code VARCHAR2)
3819: --enhancement to be commented
3820: CURSOR l_ste_csr (l_line_id NUMBER)
3821: IS
3822: SELECT os.ste_code
3823: FROM okc_statuses_b os, okc_k_lines_b ol
3824: WHERE ol.ID = l_line_id AND ol.sts_code = os.code;
3825:
3826: CURSOR l_salesgrp_csr (p_id NUMBER, p_start_date DATE, p_end_date DATE)
3827: IS
9285: CURSOR l_Launch_WF_csr (p_hdr_id NUMBER)
9286: IS
9287: SELECT 'Y'
9288: FROM okc_k_headers_b Kh, oks_k_headers_b Ks
9289: , okc_statuses_b sts
9290: WHERE Kh.ID = p_hdr_id
9291: And Ks.chr_id = Kh.id
9292: And kh.sts_code = sts.code
9293: And sts.ste_code = 'ENTERED'
9306:
9307: CURSOR l_toplines_csr (p_chr_id NUMBER, p_service_item_id NUMBER)
9308: IS
9309: SELECT kl.ID cle_id
9310: FROM okc_k_lines_b kl, okc_k_items ki, okc_statuses_b st
9311: WHERE kl.dnz_chr_id = p_chr_id
9312: AND kl.lse_id IN (1, 14, 19)
9313: AND kl.ID = ki.cle_id
9314: AND ki.object1_id1 = TO_CHAR (p_service_item_id)
10036:
10037: CURSOR l_hdr_sts_csr (p_hdr_id NUMBER)
10038: IS
10039: SELECT st.ste_code, kh.sts_code
10040: FROM okc_k_headers_b kh, okc_statuses_b st
10041: WHERE kh.ID = p_hdr_id AND st.code = kh.sts_code;
10042:
10043: -- Fix for bug 3588355
10044: CURSOR l_get_bill_ship_csr (p_cp_id NUMBER)
10303: */
10304: CURSOR l_line_sts_csr (p_line_id NUMBER)
10305: IS
10306: SELECT st.ste_code, kl.sts_code
10307: FROM okc_k_lines_b kl, okc_statuses_b st
10308: WHERE kl.ID = p_line_id AND st.code = kl.sts_code;
10309:
10310: CURSOR l_getprice_csr (p_line_id NUMBER)
10311: IS