[Home] [Help]
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
2148: from mtl_transaction_accounts mta,
2149: xla_upgrade_dates xud,
2150: hr_organization_information hoi2,
2151: org_acct_periods oap,
2152: mtl_material_transactions mmt
2212: END IF;
2213:
2214: l_stmt_num :=20;
2215:
2216: update mtl_transaction_accounts mta
2217: set inv_sub_ledger_id = cst_inv_sub_ledger_id_s.nextval,
2218: last_update_date = gUpdateDate,
2219: last_updated_by = gUserId,
2220: last_update_login = gLoginId
2448: header_id,
2449: line_id,
2450: accounting_class_code,
2451: 'C',
2452: 'MTL_TRANSACTION_ACCOUNTS',
2453: src_dist_id_num_1,
2454: 'N',
2455: header_id,
2456: line_id,
2638: mmt.transaction_source_type_id mmt_transaction_source_type_id,
2639: sign(mta.base_transaction_value) btvsign,
2640: case when mmt.transaction_action_id in (12, 21) then (
2641: select 1
2642: from mtl_transaction_accounts mta1
2643: where mta1.accounting_line_type in (9,10)
2644: and mta1.transaction_id = mta.transaction_id
2645: and mta1.organization_id = mta.organization_id
2646: and mta1.transaction_source_type_id = mta.transaction_source_type_id
2648: else null
2649: end exists_9_10,
2650: case when mmt.transaction_action_id in (12, 21) then (
2651: select 1
2652: from mtl_transaction_accounts mta1
2653: where mta1.accounting_line_type = 14
2654: and mta1.transaction_id = mta.transaction_id
2655: and mta1.organization_id = mta.organization_id
2656: and mta1.transaction_source_type_id = mta.transaction_source_type_id
2656: and mta1.transaction_source_type_id = mta.transaction_source_type_id
2657: and rownum = 1)
2658: else null
2659: end exists_14
2660: from mtl_transaction_accounts mta,
2661: mtl_material_transactions mmt,
2662: gl_code_combinations gcc,
2663: mtl_parameters mp,
2664: hr_organization_information hoi2,