APPS.OKL_STREAM_BILLING_PVT dependencies on STANDARD

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

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

Line 1344: , cp.standard_terms payment_term_id

1340:
1341: --added for rules migration
1342: CURSOR cust_acct_csr (p_khr_id NUMBER) IS
1343: SELECT cs.cust_acct_site_id
1344: , cp.standard_terms payment_term_id
1345: FROM okc_k_headers_v khr
1346: , okx_cust_site_uses_v cs
1347: , hz_customer_profiles cp
1348: WHERE khr.id = p_khr_id

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

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

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

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