332: , NULL lot_vendor
333: , NULL subinventory_code
334: , NULL LOCATOR
335: FROM wip_entities wipent
336: , wip_discrete_jobs wipdj
337: , mfg_lookups mfglkp1
338: , mfg_lookups mfglkp2
339: , mfg_lookups mfglkp3
340: , mtl_system_items_vl msik3
399: , mtl_material_transactions_temp mmtt
400: , mtl_transaction_lots_temp mtlt
401: -- bug 3075322
402: -- , mtl_item_locations mil commented for bug 3776231
403: , wip_discrete_jobs wdj -- added for bug 3776231
404: -- Bug 2673874 : joabraha
405: , pa_projects pp
406: , pa_tasks pt
407: WHERE mtrl.line_id = mmtt.move_order_line_id
440: , mtl_material_transactions_temp mmtt
441: , mtl_transaction_lots_temp mtlt
442: -- bug 3075322
443: -- , mtl_item_locations mil commented for bug 3776231
444: , wip_discrete_jobs wdj -- added for bug 3776231
445: -- Bug 2673874 : joabraha
446: , pa_projects pp
447: , pa_tasks pt
448: WHERE mtrl.line_id = mmtt.move_order_line_id
747: , mln.vendor_name lot_vendor
748: , lpn.subinventory_code subinventory_code
749: , inv_project.get_locsegs(milkfv.inventory_location_id, milkfv.organization_id) LOCATOR
750: FROM wip_entities wipent
751: , wip_discrete_jobs wipdj
752: , wip_repetitive_schedules wiprs
753: , wip_operations wipops
754: , wip_requirement_operations wipreqops
755: , mtl_item_locations mila
1053: SELECT pp.SEGMENT1
1054: , pt.TASK_NUMBER
1055: INTO l_project_name
1056: , l_task_name
1057: FROM wip_discrete_jobs wdj
1058: , pa_projects_all pp
1059: , pa_tasks pt
1060: WHERE wdj.wip_entity_id = l_wip_entity_id
1061: AND wdj.organization_id = l_organization_id