DBA Data[Home] [Help]

APPS.CSP_AUTO_ASLMSL_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 2402: mtl_material_transactions mmt,

2398: from mtl_parameters mp,
2399: mtl_system_items_b msib,
2400: mtl_item_sub_inventories misi,
2401: mtl_secondary_inventories msi,
2402: mtl_material_transactions mmt,
2403: mtl_interorg_ship_methods mism
2404: where mp.organization_id = mmt.organization_id
2405: and misi.organization_id (+) = mmt.organization_id
2406: and misi.inventory_item_id (+) = mmt.inventory_item_id

Line 2632: from mtl_material_transactions mmt

2628: fnd_global.user_id,
2629: sysdate,
2630: fnd_global.user_id,
2631: sysdate
2632: from mtl_material_transactions mmt
2633: where mmt.creation_date >
2634: decode(G_LAST_RUN_DATE,fnd_api.g_miss_date,G_LAST_RUN_DATE,
2635: 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)
2636: and mmt.transaction_action_id = g_txn_action_id