DBA Data[Home] [Help]

APPS.JA_CN_CFS_REPORT_PKG dependencies on XLA_AE_HEADERS

Line 99: Xla_Ae_Headers Aeh,

95: cursor c_trx_number is
96: SELECT Aca.Check_Number, Pv.Vendor_Name, Pv.Segment1
97: FROM Ap_Checks_All Aca,
98: Xla_Transaction_Entities Ent,
99: Xla_Ae_Headers Aeh,
100: Po_Vendors Pv
101: WHERE Ent.Application_Id = 200
102: AND Aca.Check_Id = Ent.Source_Id_Int_1
103: AND Aca.Vendor_Id = Pv.Vendor_Id(+)

Line 148: Xla_Ae_Headers Aeh,

144: /* SELECT Aca.Check_Number, Pv.Vendor_Name, Pv.Segment1
145: INTO x_Trx_Number, x_Third_Party_Name, x_Third_Party_Num
146: FROM Ap_Checks_All Aca,
147: Xla_Transaction_Entities Ent,
148: Xla_Ae_Headers Aeh,
149: Po_Vendors Pv
150: WHERE Ent.Application_Id = 200
151: AND Aca.Check_Id = Ent.Source_Id_Int_1
152: AND Aca.Vendor_Id = Pv.Vendor_Id(+)

Line 270: Xla_Ae_Headers Aeh,

266: CURSOR c_trx_number is
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

Line 315: Xla_Ae_Headers Aeh,

311: /* SELECT Aca.Receipt_Number, Hp.Party_Name, Cust.Account_Number
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