1469: and l_transaction_type_id in (32, 42) )
1470: then
1471: SELECT ml.meaning
1472: into p_material_txn_rec.TRANSACTION_TYPE
1473: from wsm_lot_split_merges wlsm
1474: , mfg_lookups ml
1475: where wlsm.transaction_id= l_source_line_id
1476: and ml.lookup_type='WSM_INV_LOT_TXN_TYPE'
1477: and ml.lookup_code=wlsm.transaction_type_id;
1644: and l_transaction_type_id in (32, 42) )
1645: then
1646: SELECT ml.meaning
1647: into p_pending_txn_rec.TRANSACTION_TYPE
1648: from wsm_lot_split_merges wlsm
1649: , mfg_lookups ml
1650: where wlsm.transaction_id= l_source_line_id
1651: and ml.lookup_type='WSM_INV_LOT_TXN_TYPE'
1652: and ml.lookup_code=wlsm.transaction_type_id;