APPS.INV_GENEALOGY_REPORT_GEN dependencies on MTL_MFG_GENEALOGY_LOTATTR_V

Line 395: ||' From mtl_mfg_genealogy_lotattr_v'

391: ||' and wip_entity_name = '||p_wip_entity_name
392: ||' Union All'
393: ||' Select gen_object_id object_id'
394: ||' , 5 object_type'
395: ||' From mtl_mfg_genealogy_lotattr_v'
396: ||' Where primary_item_id = '||g_inventory_item_id
397: ||' and organization_id = '||g_organization_id
398: ||' and wip_entity_name = '||p_wip_entity_name
399: ||' Union All'

Line 1214: from mtl_mfg_genealogy_lotattr_v

1210: , quantity_remaining
1211: , quantity_scrapped
1212: , quantity_completed
1213: , uom
1214: from mtl_mfg_genealogy_lotattr_v
1215: where wip_entity_id = p_work_order_header_rec.wip_entity_id
1216: ;
1217: Begin
1218: debug('Write Work Order Info');

Line 1267: l_from := ' from mtl_mfg_genealogy_lotattr_v';

1263: ||' , uom'
1264: ;
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: