[Home] [Help]
1881: header_id)
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) */
1949: and mta.encumbrance_type_id is null;
1950:
1951: insert all
1952: when (line_id=1) then
1953: into xla_transaction_entities (
1954: upg_batch_id,
1955: entity_id,
1956: application_id,
1957: ledger_id,
2687: header_id)
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
2738:
2739:
2740: insert all
2741: when (line_id=1) then
2742: INTO XLA_TRANSACTION_ENTITIES (
2743: upg_batch_id,
2744: entity_id,
2745: application_id,
2746: ledger_id,
3259: HOI2.organization_id,
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,
3312: l_stmt_num :=20;
3313:
3314: insert all
3315: when (line_id=1) then
3316: INTO XLA_TRANSACTION_ENTITIES (
3317: upg_batch_id,
3318: entity_id,
3319: application_id,
3320: ledger_id,