APPS.OKL_INTERNAL_TO_EXTERNAL dependencies on OKX_CUST_SITE_USES_V

Line 676: FROM okx_cust_site_uses_v

672:
673: CURSOR cust_acct_id_csr(p_id1 NUMBER) IS
674: SELECT cust_acct_site_id,
675: payment_term_id
676: FROM okx_cust_site_uses_v
677: WHERE id1 = p_id1;
678:
679: l_cust_acct_site_id okx_cust_site_uses_v.cust_acct_site_id%TYPE;
680: l_cust_bank_acct okx_rcpt_method_accounts_v.bank_account_id%TYPE;

Line 679: l_cust_acct_site_id okx_cust_site_uses_v.cust_acct_site_id%TYPE;

675: payment_term_id
676: FROM okx_cust_site_uses_v
677: WHERE id1 = p_id1;
678:
679: l_cust_acct_site_id okx_cust_site_uses_v.cust_acct_site_id%TYPE;
680: l_cust_bank_acct okx_rcpt_method_accounts_v.bank_account_id%TYPE;
681: l_payment_term_id okx_cust_site_uses_v.payment_term_id%TYPE;
682:
683: l_rulv_rec Okl_Rule_Apis_Pvt.rulv_rec_type;

Line 681: l_payment_term_id okx_cust_site_uses_v.payment_term_id%TYPE;

677: WHERE id1 = p_id1;
678:
679: l_cust_acct_site_id okx_cust_site_uses_v.cust_acct_site_id%TYPE;
680: l_cust_bank_acct okx_rcpt_method_accounts_v.bank_account_id%TYPE;
681: l_payment_term_id okx_cust_site_uses_v.payment_term_id%TYPE;
682:
683: l_rulv_rec Okl_Rule_Apis_Pvt.rulv_rec_type;
684: null_rulv_rec Okl_Rule_Apis_Pvt.rulv_rec_type;
685:

Line 721: FROM Okx_cust_site_uses_v A, okx_customer_accounts_v C

717: /*CURSOR Cur_address_billto(p_id IN VARCHAR2,Code VARCHAR2) IS
718: SELECT A.cust_account_id,
719: A.cust_acct_site_id,
720: A.payment_term_id
721: FROM Okx_cust_site_uses_v A, okx_customer_accounts_v C
722: WHERE A.id1 = p_id
723: AND C.id1 = A.cust_account_id
724: AND A.site_use_code = Code;*/
725: --added for rules migration

Line 731: okx_cust_site_uses_v b,

727: SELECT a.cust_acct_id cust_account_id,
728: b.cust_acct_site_id,
729: c.standard_terms payment_term_id
730: FROM okc_k_headers_v a,
731: okx_cust_site_uses_v b,
732: hz_customer_profiles c
733: WHERE a.id = p_contract_id
734: AND a.bill_to_site_use_id = b.id1
735: AND a.bill_to_site_use_id = c.site_use_id(+);