APPS.CST_SLA_UPDATE_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 1077: l_table_name varchar2(30) := 'MTL_MATERIAL_TRANSACTIONS';

1073: IS
1074:
1075: l_worker_id number;
1076: l_product varchar2(30);
1077: l_table_name varchar2(30) := 'MTL_MATERIAL_TRANSACTIONS';
1078: l_id_column varchar2(30) := 'TRANSACTION_ID';
1079:
1080:
1081: l_update_name varchar2(30);

Line 1889: select /*+ leading(mmt,oap) use_hash(xud, oap) swap_join_inputs(oap) index(mmt, mtl_material_transactions_u1) */

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) */
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,

Line 1896: mtl_material_transactions mmt

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
1897: where mmt.transaction_id >= X_min_id
1898: and mmt.transaction_id <= X_max_id
1899: and mmt.acct_period_id = oap.acct_period_id
1900: and mmt.organization_id = oap.organization_id

Line 1919: from mtl_material_transactions mmt1

1915: where pop.organization_id = mta.organization_id
1916: and pop.pa_posting_flag = 'Y'
1917: and exists (
1918: select 1
1919: from mtl_material_transactions mmt1
1920: where mmt1.transaction_id = mta.transaction_id
1921: and (nvl(mmt1.logical_transaction, 2) = 2
1922: or mmt1.logical_transaction = 1
1923: and mmt1.transaction_type_id = 19

Line 2382: mtl_material_transactions mmt,

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,
2386: gl_ledgers sob,