APPS.INV_GENEALOGY_REPORT_GEN dependencies on WSM_WIP_GENEALOGY_LOTATTR_V

Line 1199: from wsm_wip_genealogy_lotattr_v

1195: , quantity_remaining
1196: , quantity_scrapped
1197: , quantity_completed
1198: , uom
1199: from wsm_wip_genealogy_lotattr_v
1200: where wip_entity_id = p_work_order_header_rec.wip_entity_id
1201: ;
1202: cursor get_gme_dtl is
1203: select item_number

Line 1265: l_from := ' from wsm_wip_genealogy_lotattr_v';

1261: debug('wip_entity_type '||p_work_order_header_rec.wip_entity_type);
1262: if p_work_order_header_rec.wip_entity_type in (9, 10) then
1263: l_from := ' from mtl_mfg_genealogy_lotattr_v';
1264: else
1265: l_from := ' from wsm_wip_genealogy_lotattr_v';
1266: end if;
1267:
1268: l_where := ' where wip_entity_id = '||p_work_order_header_rec.wip_entity_id;
1269: