eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_SLA_UPDATE_PKG dependencies on RCV_RECEIVING_SUB_LEDGER

Line 3552: rcv_receiving_sub_ledger rrs

3548: (select /*+ no_merge leading(rrs) use_hash(xud) swap_join_inputs(xud) */
3549: distinct rcv_transaction_id,
3550: accounting_event_id
3551: from xla_upgrade_dates xud,
3552: rcv_receiving_sub_ledger rrs
3553: where rrs.rcv_transaction_id between x_min_id and x_max_id
3554: and xud.ledger_id = rrs.set_of_books_id
3555: and rrs.accounting_date between xud.start_date and xud.end_date
3556: and rrs.encumbrance_type_id is null

Line 3590: rcv_receiving_sub_ledger rrs

3586: /* Bug 6729184 Moved update of rcv_sub_ledger_id prior to XLA insert to avoid NULL into
3587: XDL.SOURCE_DISTRIBUTION_ID_NUM_1*/
3588:
3589: update /*+ leading(cxs) use_nl(rrs) index(rrs) */
3590: rcv_receiving_sub_ledger rrs
3591: set reference10 = 'Migrated to SLA',
3592: rcv_sub_ledger_id = nvl(rcv_sub_ledger_id, rcv_receiving_sub_ledger_s.nextval),
3593: last_update_date = gUpdateDate,
3594: last_updated_by = gUserId,

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

3588:
3589: update /*+ leading(cxs) use_nl(rrs) index(rrs) */
3590: rcv_receiving_sub_ledger rrs
3591: set reference10 = 'Migrated to SLA',
3592: rcv_sub_ledger_id = nvl(rcv_sub_ledger_id, rcv_receiving_sub_ledger_s.nextval),
3593: last_update_date = gUpdateDate,
3594: last_updated_by = gUserId,
3595: last_update_login = gLoginId
3596: where rrs.rcv_transaction_id in (select source_id_int_1 from cst_xla_seq_gt cxs)

Line 3908: 'RCV_RECEIVING_SUB_LEDGER' src_dist_type,

3904: 'UNKNOWN') accounting_class_code,
3905: rrs.gl_sl_link_id link_id,
3906: 'RSL' link_table,
3907: 'C' line_type_code,
3908: 'RCV_RECEIVING_SUB_LEDGER' src_dist_type,
3909: 'N' merge_dup_code,
3910: rrs.accounted_dr ACCOUNTED_DR,
3911: rrs.accounted_cr ACCOUNTED_CR,
3912: rrs.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE,

Line 3920: from rcv_receiving_sub_ledger rrs,

3916: rrs.entered_cr ENTERED_CR,
3917: rrs.USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE,
3918: decode(gcc.reference3,'Y', 'P', null) CONTROL_BALANCE_FLAG,
3919: cem.event_class_code event_class_code
3920: from rcv_receiving_sub_ledger rrs,
3921: cst_xla_rcv_event_map cem,
3922: GL_CODE_COMBINATIONS gcc,
3923: cst_xla_seq_gt cxs
3924: where rrs.rcv_transaction_id = cxs.source_id_int_1