DBA Data[Home] [Help]

APPS.CST_SLA_UPDATE_PKG dependencies on XLA_EVENTS

Line 1886: xla_events_s.nextval,

1882: select transaction_id,
1883: organization_id,
1884: transaction_source_type_id,
1885: xla_transaction_entities_s.nextval,
1886: xla_events_s.nextval,
1887: xla_ae_headers_s.nextval
1888: from (
1889: select /*+ leading(mmt,oap) use_hash(xud, oap) swap_join_inputs(oap) index(mmt, mtl_material_transactions_u1) */
1890: distinct

Line 1988: into xla_events (

1984: last_updated_by,
1985: last_update_login,
1986: 401,
1987: 401)
1988: into xla_events (
1989: upg_batch_id,
1990: application_id,
1991: entity_id,
1992: event_id,

Line 2692: xla_events_s.nextval,

2688: select transaction_id,
2689: resource_id,
2690: basis_type,
2691: XLA_transaction_ENTITies_S.nextval,
2692: xla_events_s.nextval,
2693: xla_ae_headers_s.NEXTVAL
2694: from (select distinct wta.transaction_id, wta.resource_id, wta.basis_type
2695: from wip_transaction_accounts wta
2696: where wta.transaction_id >= X_min_id

Line 2779: into xla_events (

2775: last_updated_by,
2776: LAST_UPDATE_LOGIN,
2777: 706,
2778: 706)
2779: into xla_events (
2780: upg_batch_id,
2781: APPLICATION_ID,
2782: entity_id,
2783: event_id,

Line 3264: xla_events_s.nextval,

3260: nvl(rae.EVENT_TYPE_ID,decode(rt.transaction_type, 'RECEIVE', 1, 'DELIVER', 2, 'CORRECT', 3,
3261: 'MATCH', 4, 'RETURN TO RECEIVING', 5, 'RETURN TO VENDOR', 6, -1)),
3262: rt.parent_transaction_id,
3263: XLA_transaction_ENTITies_S.nextval,
3264: xla_events_s.nextval,
3265: xla_ae_headers_s.NEXTVAL,
3266: null,
3267: nvl(rae.org_id,
3268: DECODE(l_multi_org_flag,'Y',TO_NUMBER(HOI2.ORG_INFORMATION3),TO_NUMBER(NULL)))

Line 3355: into xla_events (

3351: last_updated_by,
3352: LAST_UPDATE_LOGIN,
3353: 201,
3354: 201)
3355: into xla_events (
3356: upg_batch_id,
3357: APPLICATION_ID,
3358: entity_id,
3359: event_id,