DBA Data[Home] [Help]

APPS.JA_CN_AR_VALIDATION_PKG dependencies on XLA_TRANSACTION_ENTITIES

Line 110: Xla_Transaction_Entities ent,

106: JA_CN_CODE_COMBINATION_V jcc,
107: HZ_CUST_ACCOUNTS cust,
108: HZ_PARTIES part,
109: GL_PERIOD_STATUSES gps,
110: Xla_Transaction_Entities ent,
111: RA_CUSTOMER_TRX_ALL rct
112: WHERE jeh.je_header_id = jel.je_header_id
113: AND jeh.je_header_id = gir.je_header_id
114: AND jel.je_line_num = gir.je_line_num

Line 217: Xla_Transaction_Entities Ent,

213: (ln_ae_header_id NUMBER)
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'

Line 228: Xla_Transaction_Entities Ent,

224: AND Aeh.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
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'

Line 240: Xla_Transaction_Entities Ent,

236: UNION
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