APPS.CST_SLA_UPDATE_PKG dependencies on RCV_RECEIVING_SUB_LEDGER

Line 3276: rcv_receiving_sub_ledger rrs

3272: gl_ledgers sob,
3273: (select /*+ no_merge leading(rrs) use_hash(xud) swap_join_inputs(xud) */
3274: distinct rcv_transaction_id
3275: from xla_upgrade_dates xud,
3276: rcv_receiving_sub_ledger rrs
3277: where rrs.rcv_transaction_id between x_min_id and x_max_id
3278: and xud.ledger_id = rrs.set_of_books_id
3279: and rrs.accounting_date between xud.start_date and xud.end_date
3280: and rrs.encumbrance_type_id is null

Line 3302: rcv_receiving_sub_ledger rrs

3298: /* Bug 6729184 Moved update of rcv_sub_ledger_id prior to XLA insert to avoid NULL into
3299: XDL.SOURCE_DISTRIBUTION_ID_NUM_1*/
3300:
3301: update /*+ leading(cxs) use_nl(rrs) index(rrs) */
3302: rcv_receiving_sub_ledger rrs
3303: set reference10 = 'Migrated to SLA',
3304: rcv_sub_ledger_id = nvl(rcv_sub_ledger_id, rcv_receiving_sub_ledger_s.nextval),
3305: last_update_date = gUpdateDate,
3306: last_updated_by = gUserId,

Line 3304: rcv_sub_ledger_id = nvl(rcv_sub_ledger_id, rcv_receiving_sub_ledger_s.nextval),

3300:
3301: update /*+ leading(cxs) use_nl(rrs) index(rrs) */
3302: rcv_receiving_sub_ledger rrs
3303: set reference10 = 'Migrated to SLA',
3304: rcv_sub_ledger_id = nvl(rcv_sub_ledger_id, rcv_receiving_sub_ledger_s.nextval),
3305: last_update_date = gUpdateDate,
3306: last_updated_by = gUserId,
3307: last_update_login = gLoginId
3308: where rrs.rcv_transaction_id in (select source_id_int_1 from cst_xla_seq_gt cxs)

Line 3620: 'RCV_RECEIVING_SUB_LEDGER' src_dist_type,

3616: 'UNKNOWN') accounting_class_code,
3617: rrs.gl_sl_link_id link_id,
3618: 'RSL' link_table,
3619: 'C' line_type_code,
3620: 'RCV_RECEIVING_SUB_LEDGER' src_dist_type,
3621: 'N' merge_dup_code,
3622: rrs.accounted_dr ACCOUNTED_DR,
3623: rrs.accounted_cr ACCOUNTED_CR,
3624: rrs.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE,

Line 3632: from rcv_receiving_sub_ledger rrs,

3628: rrs.entered_cr ENTERED_CR,
3629: rrs.USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE,
3630: decode(gcc.reference3,'Y', 'P', null) CONTROL_BALANCE_FLAG,
3631: cem.event_class_code event_class_code
3632: from rcv_receiving_sub_ledger rrs,
3633: cst_xla_rcv_event_map cem,
3634: GL_CODE_COMBINATIONS gcc,
3635: cst_xla_seq_gt cxs
3636: where rrs.rcv_transaction_id = cxs.source_id_int_1