[Home] [Help]
1393: X_Argument9 in varchar2 default null,
1394: X_Argument10 in varchar2 default null)
1395: IS
1396:
1397: l_table_name varchar2(30) := 'MTL_MATERIAL_TRANSACTIONS';
1398: l_id_column varchar2(30) := 'TRANSACTION_ID';
1399:
1400: l_update_name varchar2(30);
1401:
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
2148: from mtl_transaction_accounts mta,
2149: xla_upgrade_dates xud,
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
2153: where mmt.transaction_id >= X_min_id
2154: and mmt.transaction_id <= X_max_id
2155: and mmt.acct_period_id = oap.acct_period_id
2156: and mmt.organization_id = oap.organization_id
2171: where pop.organization_id = mta.organization_id
2172: and pop.pa_posting_flag = 'Y'
2173: and exists (
2174: select 1
2175: from mtl_material_transactions mmt1
2176: where mmt1.transaction_id = mta.transaction_id
2177: and (nvl(mmt1.logical_transaction, 2) = 2
2178: or mmt1.logical_transaction = 1
2179: and mmt1.transaction_type_id = 19
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,
2665: gl_ledgers sob,