DBA Data[Home] [Help]

APPS.CST_SLA_UPDATE_PKG dependencies on XLA_AE_HEADERS

Line 2143: xla_ae_headers_s.nextval

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

Line 2311: into xla_ae_headers (

2307: program_id,
2308: request_id,
2309: transaction_date,
2310: 401)
2311: into xla_ae_headers (
2312: upg_batch_id,
2313: application_id,
2314: amb_context_code,
2315: entity_id,

Line 2949: xla_ae_headers_s.NEXTVAL

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

Line 3093: into xla_ae_headers (

3089: PROGRAM_ID,
3090: REQUEST_ID,
3091: TRANSACTION_DATE,
3092: 706)
3093: into xla_ae_headers (
3094: upg_batch_id,
3095: application_id,
3096: AMB_CONTEXT_CODE,
3097: entity_id,

Line 3540: xla_ae_headers_s.NEXTVAL,

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

Line 3686: into xla_ae_headers (

3682: PROGRAM_ID,
3683: REQUEST_ID,
3684: TRANSACTION_DATE,
3685: 201)
3686: into xla_ae_headers (
3687: upg_batch_id,
3688: application_id,
3689: AMB_CONTEXT_CODE,
3690: entity_id,