DBA Data[Home] [Help]

APPS.JA_CN_CFS_REPORT_PKG dependencies on HZ_CUST_ACCOUNTS

Line 271: Hz_Cust_Accounts Cust,

267: SELECT Aca.Receipt_Number, Hp.Party_Name, Cust.Account_Number
268: FROM Ar_Cash_Receipts_All Aca,
269: Xla_Transaction_Entities Ent,
270: Xla_Ae_Headers Aeh,
271: Hz_Cust_Accounts Cust,
272: Hz_Parties Hp
273: WHERE Ent.Application_Id = 222
274: AND Aca.Cash_Receipt_Id = Ent.Source_Id_Int_1
275: AND Aca.Pay_From_Customer = Cust.Cust_Account_Id(+)

Line 316: Hz_Cust_Accounts Cust,

312: INTO x_Trx_Number, x_Third_Party_Name, x_Third_Party_Num
313: FROM Ar_Cash_Receipts_All Aca,
314: Xla_Transaction_Entities Ent,
315: Xla_Ae_Headers Aeh,
316: Hz_Cust_Accounts Cust,
317: Hz_Parties Hp
318: WHERE Ent.Application_Id = 222
319: AND Aca.Cash_Receipt_Id = Ent.Source_Id_Int_1
320: AND Aca.Pay_From_Customer = Cust.Cust_Account_Id(+)