DBA Data[Home] [Help]

APPS.CST_SLA_UPDATE_PKG dependencies on XLA_EVENTS

Line 2142: xla_events_s.nextval,

2138: select transaction_id,
2139: organization_id,
2140: transaction_source_type_id,
2141: xla_transaction_entities_s.nextval,
2142: xla_events_s.nextval,
2143: xla_ae_headers_s.nextval
2144: from (
2145: select /*+ leading(mmt,oap) use_hash(xud, oap) swap_join_inputs(oap) index(mmt, mtl_material_transactions_u1) */
2146: distinct

Line 2268: into xla_events (

2264: last_updated_by,
2265: last_update_login,
2266: 401,
2267: 401)
2268: into xla_events (
2269: upg_batch_id,
2270: application_id,
2271: entity_id,
2272: event_id,

Line 2948: xla_events_s.nextval,

2944: select transaction_id,
2945: resource_id,
2946: basis_type,
2947: XLA_transaction_ENTITies_S.nextval,
2948: xla_events_s.nextval,
2949: xla_ae_headers_s.NEXTVAL
2950: from (select distinct wta.transaction_id, wta.resource_id, wta.basis_type
2951: from wip_transaction_accounts wta
2952: where wta.transaction_id >= X_min_id

Line 3050: into xla_events (

3046: last_updated_by,
3047: LAST_UPDATE_LOGIN,
3048: 706,
3049: 706)
3050: into xla_events (
3051: upg_batch_id,
3052: APPLICATION_ID,
3053: entity_id,
3054: event_id,

Line 3539: xla_events_s.nextval,

3535: nvl(rae.EVENT_TYPE_ID,decode(rt.transaction_type, 'RECEIVE', 1, 'DELIVER', 2, 'CORRECT', 3,
3536: 'MATCH', 4, 'RETURN TO RECEIVING', 5, 'RETURN TO VENDOR', 6, -1)),
3537: rt.parent_transaction_id,
3538: XLA_transaction_ENTITies_S.nextval,
3539: xla_events_s.nextval,
3540: xla_ae_headers_s.NEXTVAL,
3541: null,
3542: nvl(rae.org_id,
3543: DECODE(l_multi_org_flag,'Y',TO_NUMBER(HOI2.ORG_INFORMATION3),TO_NUMBER(NULL)))

Line 3643: into xla_events (

3639: last_updated_by,
3640: LAST_UPDATE_LOGIN,
3641: 201,
3642: 201)
3643: into xla_events (
3644: upg_batch_id,
3645: APPLICATION_ID,
3646: entity_id,
3647: event_id,