31: l_stmt_num := 10;
32: SELECT count(*)
33: INTO l_mmtt
34: FROM mtl_material_transactions_temp mmtt,
35: mtl_parameters MP
36: WHERE mmtt.organization_id = MP.organization_id and
37: MP.wsm_enabled_flag = 'Y' and
38: mmtt.transaction_source_type_id = 5 and
39: mmtt.transaction_status <> 2 and
43: l_stmt_num := 20;
44: SELECT count(*)
45: INTO l_uncosted_mmt
46: FROM mtl_material_transactions mmt,
47: mtl_parameters MP
48: WHERE mmt.organization_id = MP.organization_id and
49: mmt.costed_flag IN ('N','E') and
50: MP.wsm_enabled_flag = 'Y' and
51: mmt.transaction_source_type_id = 5 and