DBA Data[Home] [Help]

APPS.OKL_REPORT_PVT dependencies on OKX_PARTIES_V

Line 4542: FROM okx_parties_v hp,

4538: -- Customer Name, Customer Account Number
4539: CURSOR c_cust_name(cp_cust_acct_id IN NUMBER) IS
4540: SELECT name,
4541: hca.account_number
4542: FROM okx_parties_v hp,
4543: hz_cust_accounts hca
4544: WHERE hp.id1 = hca.party_id
4545: AND hca.cust_account_id = cp_cust_acct_id;
4546:

Line 4797: l_party_name okx_parties_v.name%TYPE;

4793: l_ext_line_receipt_method_name okx_receipt_methods_v.name%TYPE;
4794: l_rct_method_code ar_receipt_classes.creation_method_code%TYPE;
4795: l_ext_customer_id Okl_Ext_Sell_Invs_V.customer_id%TYPE;
4796: l_ext_receipt_method_id Okl_Ext_Sell_Invs_V.receipt_method_id%TYPE;
4797: l_party_name okx_parties_v.name%TYPE;
4798: l_ext_addr_id okx_cust_site_uses_v.cust_acct_site_id%TYPE;
4799: l_cust_site_name okx_cust_sites_v.description%TYPE;
4800: l_pmth_id1 okc_rules_b.object1_id1%TYPE;
4801: l_ext_line_addr_id okl_ext_sell_invs_v.customer_address_id%TYPE;