DBA Data[Home] [Help]

APPS.JA_CN_AR_VALIDATION_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 111: RA_CUSTOMER_TRX_ALL rct

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
115: AND gir.gl_sl_link_id = ael.gl_sl_link_id

Line 216: FROM RA_CUSTOMER_TRX_ALL Rct,

212: CURSOR trx_receipt_num_cur
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

Line 238: FROM RA_CUSTOMER_TRX_ALL Rct,

234: AND Aeh.Ae_Header_Id = ln_ae_header_id --variable: ln_ae_header_id
235: AND Aeh.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
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