APPS.OKL_STREAM_BILLING_PVT dependencies on STANDARD

Line 369: AND cp.standard_terms = term.term_id;

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
369: AND cp.standard_terms = term.term_id;
370:
371: l_printing_lead_days NUMBER := 0;
372: BEGIN
373: OPEN c_lead_days(p_khr_id);

Line 1282: , cp.standard_terms payment_term_id

1278:
1279: --added for rules migration
1280: CURSOR cust_acct_csr (p_khr_id NUMBER) IS
1281: SELECT cs.cust_acct_site_id
1282: , cp.standard_terms payment_term_id
1283: FROM okc_k_headers_v khr
1284: , okx_cust_site_uses_v cs
1285: , hz_customer_profiles cp
1286: WHERE khr.id = p_khr_id

Line 1293: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id

1289:
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

Line 1305: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id

1301: AND cle.id = p_kle_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