DBA Data[Home] [Help]

APPS.JA_CN_AP_VALIDATION_PKG dependencies on XLA_AE_HEADERS

Line 77: Xla_Ae_Headers Aeh

73: IS
74: SELECT Aia.Invoice_Id Invoice_Id
75: FROM Ap_Invoices_All Aia,
76: Xla_Transaction_Entities Ent,
77: Xla_Ae_Headers Aeh
78: WHERE Ent.Application_Id = 200
79: AND Aia.Invoice_Id = Ent.Source_Id_Int_1
80: AND Ent.Entity_Code = 'AP_INVOICES'
81: AND Ent.Entity_Id = Aeh.Entity_Id

Line 90: Xla_Ae_Headers Aeh

86: FROM Ap_Invoices_All Aia,
87: Ap_Checks_All Ach,
88: Ap_Invoice_Payments_All Aip,
89: Xla_Transaction_Entities Ent,
90: Xla_Ae_Headers Aeh
91: WHERE Ent.Application_Id = 200
92: AND Aia.Invoice_Id = Aip.Invoice_Id
93: AND Ach.Check_Id = Aip.Check_Id
94: AND Ach.Check_Id = Ent.Source_Id_Int_1

Line 210: Xla_Ae_Headers Aeh,

206: Ja_Cn_Code_Combination_v Jcc,
207: Gl_Ledgers Gl,
208: Gl_Periods Gp,
209: Xla_Ae_Lines Ael,
210: Xla_Ae_Headers Aeh,
211: Ap_Suppliers Sup,
212: Xla_Transaction_Entities Ent,
213: Ap_Invoices_All Aia
214: WHERE Jel.Je_Header_Id = Jeh.Je_Header_Id

Line 279: Xla_Ae_Headers Aeh,

275: Ja_Cn_Code_Combination_v Jcc,
276: Gl_Ledgers Gl,
277: Gl_Periods Gp,
278: Xla_Ae_Lines Ael,
279: Xla_Ae_Headers Aeh,
280: Ap_Suppliers Sup
281: WHERE Jel.Je_Header_Id = Jeh.Je_Header_Id
282: AND Gir.Je_Header_Id = Jeh.Je_Header_Id
283: AND Gir.Je_Line_Num = Jel.Je_Line_Num

Line 341: Xla_Ae_Headers Aeh

337: IS
338: SELECT Aia.Invoice_Num Inv_Pay_Number
339: FROM Ap_Invoices_All Aia,
340: Xla_Transaction_Entities Ent,
341: Xla_Ae_Headers Aeh
342: WHERE Ent.Application_Id = 200
343: AND Aia.Invoice_Id = Ent.Source_Id_Int_1
344: AND Ent.Entity_Code = 'AP_INVOICES'
345: AND Ent.Entity_Id = Aeh.Entity_Id

Line 352: Xla_Ae_Headers Aeh

348: UNION
349: SELECT TO_CHAR(Aca.Check_Number) Inv_Pay_Number
350: FROM Ap_Checks_All Aca,
351: Xla_Transaction_Entities Ent,
352: Xla_Ae_Headers Aeh
353: WHERE Ent.Application_Id = 200
354: AND Aca.Check_Id = Ent.Source_Id_Int_1
355: AND Ent.Entity_Code = 'AP_PAYMENTS'
356: AND Ent.Entity_Id = Aeh.Entity_Id