APPS.RCV_SLA_MRC_UPDATE_PKG dependencies on RCV_MC_REC_SUB_LEDGER

Line 163: rcv_mc_rec_sub_ledger rrs,

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,
166: cst_xla_seq_gt cxs
167: where rt.transaction_id=cxs.source_id_int_1

Line 291: rcv_mc_rec_sub_ledger rrs,

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,
293: GL_CODE_COMBINATIONS gcc,
294: cst_xla_seq_gt cxs
295: where rt.transaction_id=cxs.source_id_int_1

Line 325: rcv_mc_rec_sub_ledger rrs

321: and gcc.CODE_COMBINATION_ID=rrs.CODE_COMBINATION_ID;
322:
323:
324: update /*+ leading(cxs) use_nl(rrs) index(rrs) */
325: rcv_mc_rec_sub_ledger rrs
326: set reference10 = 'Migrated to SLA',
327: rcv_sub_ledger_id = nvl(rcv_sub_ledger_id, rcv_receiving_sub_ledger_s.nextval),
328: last_update_date = gUpdateDate,
329: last_updated_by = gUserId,