DBA Data[Home] [Help]

APPS.FUN_NET_EXTRACT_PKG dependencies on HZ_CUST_ACCOUNTS_ALL

Line 76: hz_cust_accounts_all hca,

72: nat.netted_amt netted_amount
73: FROM fun_net_ar_txns nat,
74: ra_customer_trx_all rct,
75: hz_parties hp,
76: hz_cust_accounts_all hca,
77: hz_cust_site_uses_all hcs,
78: fun_net_customers_all nc,
79: ra_cust_trx_line_gl_dist_all rctl
80: WHERE nat.batch_id = p_batch_id

Line 101: l_customer_number hz_cust_accounts_all.account_number%TYPE;

97:
98: l_batch_details c_get_batch_details%ROWTYPE;
99: l_agreement_details c_get_agreement_details%ROWTYPE;
100: l_customer hz_parties.party_name%TYPE;
101: l_customer_number hz_cust_accounts_all.account_number%TYPE;
102: l_location hz_cust_site_uses_all.location%TYPE;
103: l_supplier po_vendors.vendor_name%TYPE;
104: l_supplier_number po_vendors.segment1%TYPE;
105: l_supplier_site po_vendor_sites_all.vendor_site_code%TYPE;