DBA Data[Home] [Help]

APPS.JA_CN_AR_VALIDATION_PKG dependencies on XLA_AE_HEADERS

Line 105: XLA_AE_HEADERS aeh,

101: FROM GL_JE_HEADERS jeh,
102: GL_JE_LINES jel,
103: GL_IMPORT_REFERENCES gir,
104: XLA_AE_LINES ael,
105: XLA_AE_HEADERS aeh,
106: JA_CN_CODE_COMBINATION_V jcc,
107: HZ_CUST_ACCOUNTS cust,
108: HZ_PARTIES part,
109: GL_PERIOD_STATUSES gps,

Line 165: XLA_AE_HEADERS aeh,

161: FROM GL_JE_HEADERS jeh,
162: GL_JE_LINES jel,
163: GL_IMPORT_REFERENCES gir,
164: XLA_AE_LINES ael,
165: XLA_AE_HEADERS aeh,
166: JA_CN_CODE_COMBINATION_V jcc,
167: HZ_CUST_ACCOUNTS cust,
168: HZ_PARTIES part,
169: GL_PERIOD_STATUSES gps

Line 218: Xla_Ae_Headers Aeh

214: IS
215: SELECT Rct.Trx_Number Trx_Receipt_Number
216: FROM RA_CUSTOMER_TRX_ALL Rct,
217: Xla_Transaction_Entities Ent,
218: Xla_Ae_Headers Aeh
219: WHERE Ent.Application_Id = 222
220: AND Rct.Customer_Trx_Id = Ent.Source_Id_Int_1
221: AND Ent.Entity_Code = 'TRANSACTIONS'
222: AND Ent.Entity_Id = Aeh.Entity_Id

Line 229: Xla_Ae_Headers Aeh

225: UNION
226: SELECT Acr.Receipt_Number Trx_Receipt_Number
227: FROM AR_CASH_RECEIPTS_ALL Acr,
228: Xla_Transaction_Entities Ent,
229: Xla_Ae_Headers Aeh
230: WHERE Ent.Application_Id = 222
231: AND Acr.Cash_Receipt_Id = Ent.Source_Id_Int_1
232: AND Ent.Entity_Code = 'RECEIPTS'
233: AND Ent.Entity_Id = Aeh.Entity_Id

Line 241: Xla_Ae_Headers Aeh

237: SELECT Rct.Trx_Number Trx_Receipt_Number
238: FROM RA_CUSTOMER_TRX_ALL Rct,
239: AR_ADJUSTMENTS_ALL Adj,
240: Xla_Transaction_Entities Ent,
241: Xla_Ae_Headers Aeh
242: WHERE Adj.Customer_Trx_Id = Rct.Customer_Trx_Id
243: AND Ent.Application_Id = 222
244: AND Adj.Adjustment_Id = Ent.Source_Id_Int_1
245: AND Ent.Entity_Code = 'ADJUSTMENTS'