1199: , quantity_remaining
1200: , quantity_scrapped
1201: , quantity_completed
1202: , uom
1203: from wsm_wip_genealogy_lotattr_v
1204: where wip_entity_id = p_work_order_header_rec.wip_entity_id
1205: ;
1206: cursor get_gme_dtl is
1207: select item_number
1265: debug('wip_entity_type '||p_work_order_header_rec.wip_entity_type);
1266: if p_work_order_header_rec.wip_entity_type in (9, 10) then
1267: l_from := ' from mtl_mfg_genealogy_lotattr_v';
1268: else
1269: l_from := ' from wsm_wip_genealogy_lotattr_v';
1270: end if;
1271:
1272: l_where := ' where wip_entity_id = '||p_work_order_header_rec.wip_entity_id;
1273: