APPS.CSP_AUTO_ASLMSL_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 2422: mtl_material_transactions mmt,

2418: from mtl_parameters mp,
2419: mtl_system_items_b msib,
2420: mtl_item_sub_inventories misi,
2421: mtl_secondary_inventories msi,
2422: mtl_material_transactions mmt,
2423: mtl_interorg_ship_methods mism
2424: where mp.organization_id = mmt.organization_id
2425: and misi.organization_id (+) = mmt.organization_id
2426: and misi.inventory_item_id (+) = mmt.inventory_item_id

Line 2652: from mtl_material_transactions mmt

2648: fnd_global.user_id,
2649: sysdate,
2650: fnd_global.user_id,
2651: sysdate
2652: from mtl_material_transactions mmt
2653: where mmt.creation_date >
2654: decode(G_LAST_RUN_DATE,fnd_api.g_miss_date,G_LAST_RUN_DATE,
2655: to_date(to_char(G_LAST_RUN_DATE,'dd/mm/yy') || ' 23:59:59','dd/mm/yy hh24:mi:ss')) And mmt.creation_date < trunc(sysdate)
2656: and mmt.transaction_action_id = g_txn_action_id