450: i_prog_id,
451: SYSDATE,
452: i_login_id
453: FROM mtl_material_transactions MMT,
454: mtl_cst_actual_cost_details MCACD
455: WHERE MMT.transaction_action_id = 1
456: AND MMT.transaction_source_type_id = 2
457: AND MMT.organization_id = i_txn_org_id
458: AND MMT.inventory_item_id = i_item_id