DBA Data[Home] [Help]

APPS.ARP_PROCESS_CREDIT_UTIL dependencies on HZ_CUST_ACCOUNTS

Line 60: hz_cust_accounts.cust_account_id%type,

56: fnd_currencies.currency_code%type,
57: p_cust_trx_type_id IN
58: ra_cust_trx_types.cust_trx_type_id%type,
59: p_ship_to_customer_id IN
60: hz_cust_accounts.cust_account_id%type,
61: p_ship_to_site_use_id IN
62: hz_cust_site_uses.site_use_id%type,
63: p_ship_to_contact_id IN
64: hz_cust_account_roles.cust_account_role_id%type,

Line 66: hz_cust_accounts.cust_account_id%type,

62: hz_cust_site_uses.site_use_id%type,
63: p_ship_to_contact_id IN
64: hz_cust_account_roles.cust_account_role_id%type,
65: p_bill_to_customer_id IN
66: hz_cust_accounts.cust_account_id%type,
67: p_bill_to_site_use_id IN
68: hz_cust_site_uses.site_use_id%type,
69: p_bill_to_contact_id IN
70: hz_cust_account_roles.cust_account_role_id%type,

Line 78: hz_cust_accounts.cust_account_id%type,

74: ar_receipt_methods.receipt_method_id%type,
75: p_customer_bank_account_id IN
76: ce_bank_accounts.bank_account_id%type,
77: p_paying_customer_id IN
78: hz_cust_accounts.cust_account_id%type,
79: p_paying_site_use_id IN
80: hz_cust_site_uses.site_use_id%type,
81: p_ship_via IN
82: ra_customer_trx.ship_via%type,

Line 112: hz_cust_accounts.cust_account_id%type,

108: p_batch_gl_date IN
109: ra_batches.gl_date%type,
110: --
111: p_crtrx_ship_to_customer_id IN
112: hz_cust_accounts.cust_account_id%type,
113: p_crtrx_ship_to_site_use_id IN
114: hz_cust_site_uses.site_use_id%type,
115: p_crtrx_ship_to_contact_id IN
116: hz_cust_account_roles.cust_account_role_id%type,

Line 118: hz_cust_accounts.cust_account_id%type,

114: hz_cust_site_uses.site_use_id%type,
115: p_crtrx_ship_to_contact_id IN
116: hz_cust_account_roles.cust_account_role_id%type,
117: p_crtrx_bill_to_customer_id IN
118: hz_cust_accounts.cust_account_id%type,
119: p_crtrx_bill_to_site_use_id IN
120: hz_cust_site_uses.site_use_id%type,
121: p_crtrx_bill_to_contact_id IN
122: hz_cust_account_roles.cust_account_role_id%type,

Line 177: hz_cust_accounts.cust_account_id%type,

173: --
174: p_default_gl_date OUT NOCOPY
175: ra_cust_trx_line_gl_dist.gl_date%type,
176: p_default_ship_to_customer_id OUT NOCOPY
177: hz_cust_accounts.cust_account_id%type,
178: p_default_ship_to_site_use_id OUT NOCOPY
179: hz_cust_site_uses.site_use_id%type,
180: p_default_ship_to_contact_id OUT NOCOPY
181: hz_cust_account_roles.cust_account_role_id%type,

Line 183: hz_cust_accounts.cust_account_id%type,

179: hz_cust_site_uses.site_use_id%type,
180: p_default_ship_to_contact_id OUT NOCOPY
181: hz_cust_account_roles.cust_account_role_id%type,
182: p_default_bill_to_customer_id OUT NOCOPY
183: hz_cust_accounts.cust_account_id%type,
184: p_default_bill_to_site_use_id OUT NOCOPY
185: hz_cust_site_uses.site_use_id%type,
186: p_default_bill_to_contact_id OUT NOCOPY
187: hz_cust_account_roles.cust_account_role_id%type,

Line 195: hz_cust_accounts.cust_account_id%type,

191: ar_receipt_methods.receipt_method_id%type,
192: p_default_cust_bank_account_id OUT NOCOPY
193: ce_bank_accounts.bank_account_id%type,
194: p_default_paying_customer_id OUT NOCOPY
195: hz_cust_accounts.cust_account_id%type,
196: p_default_paying_site_use_id OUT NOCOPY
197: hz_cust_site_uses.site_use_id%type,
198: p_default_ship_via OUT NOCOPY
199: ra_customer_trx.ship_via%type,

Line 216: hz_cust_accounts.cust_account_id%type,

212: ra_customer_trx.customer_trx_id%type,
213: p_site_use_id IN
214: hz_cust_site_uses.site_use_id%type,
215: p_parent_customer_id IN
216: hz_cust_accounts.cust_account_id%type,
217: p_parent_site_use_id IN
218: hz_cust_site_uses.site_use_id%type,
219: p_currency_code IN
220: fnd_currencies.currency_code%type,

Line 237: hz_cust_accounts.cust_account_id%type,

233: ra_customer_trx.trx_date%type,
234: p_currency_code IN
235: fnd_currencies.currency_code%type,
236: p_bill_to_customer_id IN
237: hz_cust_accounts.cust_account_id%type,
238: p_bill_to_site_use_id IN
239: hz_cust_site_uses.site_use_id%type,
240: p_parent_customer_id IN
241: hz_cust_accounts.cust_account_id%type,

Line 241: hz_cust_accounts.cust_account_id%type,

237: hz_cust_accounts.cust_account_id%type,
238: p_bill_to_site_use_id IN
239: hz_cust_site_uses.site_use_id%type,
240: p_parent_customer_id IN
241: hz_cust_accounts.cust_account_id%type,
242: p_parent_site_use_id IN
243: hz_cust_site_uses.site_use_id%type,
244: p_crtrx_cust_bank_account_id IN
245: ce_bank_accounts.bank_account_id%type,

Line 249: hz_cust_accounts.cust_account_id%type)

245: ce_bank_accounts.bank_account_id%type,
246: p_cust_bank_account_id OUT NOCOPY
247: ce_bank_accounts.bank_account_id%type,
248: p_paying_customer_id OUT NOCOPY
249: hz_cust_accounts.cust_account_id%type)
250: RETURN BOOLEAN;
251:
252: FUNCTION check_cm_trxtype (
253: p_inv_trx_type_id IN