[Home] [Help]
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
1892: from mtl_transaction_accounts mta,
1893: xla_upgrade_dates xud,
1894: hr_organization_information hoi2,
1895: org_acct_periods oap,
1896: mtl_material_transactions mmt
1934: IF (l_rows_processed = 0) THEN
1935: RETURN;
1936: END IF;
1937:
1938: update mtl_transaction_accounts mta
1939: set inv_sub_ledger_id = cst_inv_sub_ledger_id_s.nextval,
1940: last_update_date = gUpdateDate,
1941: last_updated_by = gUserId,
1942: last_update_login = gLoginId
2168: header_id,
2169: line_id,
2170: accounting_class_code,
2171: 'C',
2172: 'MTL_TRANSACTION_ACCOUNTS',
2173: src_dist_id_num_1,
2174: 'N',
2175: header_id,
2176: line_id,
2359: mmt.transaction_source_type_id mmt_transaction_source_type_id,
2360: sign(mta.base_transaction_value) btvsign,
2361: case when mmt.transaction_action_id in (12, 21) then (
2362: select 1
2363: from mtl_transaction_accounts mta1
2364: where mta1.accounting_line_type in (9,10)
2365: and mta1.transaction_id = mta.transaction_id
2366: and mta1.organization_id = mta.organization_id
2367: and mta1.transaction_source_type_id = mta.transaction_source_type_id
2369: else null
2370: end exists_9_10,
2371: case when mmt.transaction_action_id in (12, 21) then (
2372: select 1
2373: from mtl_transaction_accounts mta1
2374: where mta1.accounting_line_type = 14
2375: and mta1.transaction_id = mta.transaction_id
2376: and mta1.organization_id = mta.organization_id
2377: and mta1.transaction_source_type_id = mta.transaction_source_type_id
2377: and mta1.transaction_source_type_id = mta.transaction_source_type_id
2378: and rownum = 1)
2379: else null
2380: end exists_14
2381: from mtl_transaction_accounts mta,
2382: mtl_material_transactions mmt,
2383: gl_code_combinations gcc,
2384: mtl_parameters mp,
2385: hr_organization_information hoi2,