DBA Data[Home] [Help]

APPS.CST_SLA_UPDATE_PKG dependencies on XLA_TRANSACTION_ENTITIES

Line 2141: xla_transaction_entities_s.nextval,

2137: header_id)
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) */

Line 2233: into xla_transaction_entities (

2229: l_stmt_num :=30;
2230:
2231: insert all
2232: when (line_id=1) then
2233: into xla_transaction_entities (
2234: upg_batch_id,
2235: entity_id,
2236: application_id,
2237: ledger_id,

Line 2947: XLA_transaction_ENTITies_S.nextval,

2943: header_id)
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

Line 3013: INTO XLA_TRANSACTION_ENTITIES (

3009: l_stmt_num :=30;
3010:
3011: insert all
3012: when (line_id=1) then
3013: INTO XLA_TRANSACTION_ENTITIES (
3014: upg_batch_id,
3015: entity_id,
3016: application_id,
3017: ledger_id,

Line 3538: XLA_transaction_ENTITies_S.nextval,

3534: HOI2.organization_id,
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,

Line 3604: INTO XLA_TRANSACTION_ENTITIES (

3600: l_stmt_num :=30;
3601:
3602: insert all
3603: when (line_id=1) then
3604: INTO XLA_TRANSACTION_ENTITIES (
3605: upg_batch_id,
3606: entity_id,
3607: application_id,
3608: ledger_id,