DBA Data[Home] [Help]

APPS.RCV_SLA_MRC_UPDATE_PKG dependencies on RCV_TRANSACTIONS

Line 161: rcv_transactions rt,

157: 201 UPG_SOURCE_APPLICATION_ID,
158: rrs.je_header_name description,
159: row_number() over(partition by rt.transaction_id,rae.accounting_event_id,NVL(rae.ORGANIZATION_ID, rt.ORGANIZATION_ID),rrs.set_of_books_id order by rt.transaction_id) as line_id
160: from rcv_mc_transactions rmt,
161: rcv_transactions rt,
162: rcv_accounting_events rae,
163: rcv_mc_rec_sub_ledger rrs,
164: cst_xla_rcv_event_map cem,
165: GL_CODE_COMBINATIONS gcc,

Line 189: FROM RCV_TRANSACTIONS rt1

185: or
186: (cem.transaction_type_id = 3
187: and rt.PARENT_TRANSACTION_ID is not null
188: and cem.attribute = (SELECT TRANSACTION_TYPE
189: FROM RCV_TRANSACTIONS rt1
190: WHERE rt1.transaction_id = rt.PARENT_TRANSACTION_ID))
191: )
192: and gcc.CODE_COMBINATION_ID=rrs.CODE_COMBINATION_ID;
193:

Line 288: from rcv_transactions rt,

284: rrs.request_id REQUEST_ID,
285: rrs.je_line_description je_line_description,
286: rrs.accounting_date accounting_date,
287: rrs.set_of_books_id ledger_id
288: from rcv_transactions rt,
289: rcv_accounting_events rae,
290: xla_ae_headers xla,
291: rcv_mc_rec_sub_ledger rrs,
292: cst_xla_rcv_event_map cem,

Line 318: FROM RCV_TRANSACTIONS rt1

314: or
315: (cem.transaction_type_id = 3
316: and rt.PARENT_TRANSACTION_ID is not null
317: and cem.attribute = (SELECT TRANSACTION_TYPE
318: FROM RCV_TRANSACTIONS rt1
319: WHERE rt1.transaction_id = rt.PARENT_TRANSACTION_ID))
320: )
321: and gcc.CODE_COMBINATION_ID=rrs.CODE_COMBINATION_ID;
322: