DBA Data[Home] [Help]

APPS.EAM_REBUILD_GENEALOGY dependencies on WIP_DISCRETE_JOBS

Line 122: from wip_discrete_jobs wdj, mtl_serial_numbers msn

118: -- check if there is an open work order against the rebuild item. If the parent does not correspond to the charge asset in the work order, there is an error. If the charge asset is null, this is not a problem.
119:
120: begin
121: select msn.gen_object_id into l_charge_object_id
122: from wip_discrete_jobs wdj, mtl_serial_numbers msn
123: where wdj.rebuild_serial_number = l_serial_number
124: and wdj.rebuild_item_id = l_inventory_item_id
125: and wdj.organization_id = l_organization_id
126: and msn.serial_number = wdj.asset_number