DBA Data[Home] [Help]

APPS.CST_SLA_UPDATE_PKG dependencies on XLA_AE_HEADERS

Line 1887: xla_ae_headers_s.nextval

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
1891: mta.transaction_id, mta.organization_id, mta.transaction_source_type_id

Line 2031: into xla_ae_headers (

2027: program_id,
2028: request_id,
2029: transaction_date,
2030: 401)
2031: into xla_ae_headers (
2032: upg_batch_id,
2033: application_id,
2034: amb_context_code,
2035: entity_id,

Line 2693: xla_ae_headers_s.NEXTVAL

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
2697: and wta.transaction_id <= X_max_id

Line 2822: into xla_ae_headers (

2818: PROGRAM_ID,
2819: REQUEST_ID,
2820: TRANSACTION_DATE,
2821: 706)
2822: into xla_ae_headers (
2823: upg_batch_id,
2824: application_id,
2825: AMB_CONTEXT_CODE,
2826: entity_id,

Line 3265: xla_ae_headers_s.NEXTVAL,

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)))
3269: from rcv_transactions rt,

Line 3398: into xla_ae_headers (

3394: PROGRAM_ID,
3395: REQUEST_ID,
3396: TRANSACTION_DATE,
3397: 201)
3398: into xla_ae_headers (
3399: upg_batch_id,
3400: application_id,
3401: AMB_CONTEXT_CODE,
3402: entity_id,