DBA Data[Home] [Help]

APPS.INV_GENEALOGY_REPORT_GEN dependencies on MTL_MFG_GENEALOGY_LOTATTR_V

Line 391: ||' From mtl_mfg_genealogy_lotattr_v'

387: ||' and wip_entity_name = '||p_wip_entity_name
388: ||' Union All'
389: ||' Select gen_object_id object_id'
390: ||' , 5 object_type'
391: ||' From mtl_mfg_genealogy_lotattr_v'
392: ||' Where primary_item_id = '||g_inventory_item_id
393: ||' and organization_id = '||g_organization_id
394: ||' and wip_entity_name = '||p_wip_entity_name
395: ||' Union All'

Line 1210: from mtl_mfg_genealogy_lotattr_v

1206: , quantity_remaining
1207: , quantity_scrapped
1208: , quantity_completed
1209: , uom
1210: from mtl_mfg_genealogy_lotattr_v
1211: where wip_entity_id = p_work_order_header_rec.wip_entity_id
1212: ;
1213: Begin
1214: debug('Write Work Order Info');

Line 1263: l_from := ' from mtl_mfg_genealogy_lotattr_v';

1259: ||' , uom'
1260: ;
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: