APPS.OKL_REPORT_PVT dependencies on OKX_CUST_SITES_V

Line 4408: p_cust_site_name IN okx_cust_sites_v.description%TYPE,

4404:
4405: PROCEDURE insert_gt(p_contract_number IN okc_k_headers_all_b.contract_number%TYPE,
4406: p_party_name in hz_parties.party_name%TYPE,
4407: p_account_number IN hz_cust_accounts.account_number%TYPE ,
4408: p_cust_site_name IN okx_cust_sites_v.description%TYPE,
4409: p_inv_msg IN fnd_new_messages.message_text%TYPE,
4410: p_value IN VARCHAR2
4411:
4412: ) IS

Line 4550: FROM okx_cust_sites_v

4546:
4547: -- Customer Site Name
4548: CURSOR c_cust_site_name(cp_cust_acct_site_id IN okx_cust_site_uses_v.cust_acct_site_id%TYPE) IS
4549: SELECT description
4550: FROM okx_cust_sites_v
4551: WHERE cust_acct_site_id = cp_cust_acct_site_id;
4552:
4553: -- K level Payment method
4554: CURSOR cust_pmth_csr ( p_khr_id IN NUMBER ) IS

Line 4800: l_cust_site_name okx_cust_sites_v.description%TYPE;

4796: l_ext_customer_id Okl_Ext_Sell_Invs_V.customer_id%TYPE;
4797: l_ext_receipt_method_id Okl_Ext_Sell_Invs_V.receipt_method_id%TYPE;
4798: l_party_name okx_parties_v.name%TYPE;
4799: l_ext_addr_id okx_cust_site_uses_v.cust_acct_site_id%TYPE;
4800: l_cust_site_name okx_cust_sites_v.description%TYPE;
4801: l_pmth_id1 okc_rules_b.object1_id1%TYPE;
4802: l_ext_line_addr_id okl_ext_sell_invs_v.customer_address_id%TYPE;
4803: l_pmth_line_id1 okc_rules_b.object1_id1%TYPE;
4804: l_ext_line_receipt_method_id Okl_Ext_Sell_Invs_V.receipt_method_id%TYPE;