DBA Data[Home] [Help]

APPS.EAM_REBUILDS_PVT dependencies on WIP_DISCRETE_JOBS

Line 136: from wip_discrete_jobs wdj, mtl_serial_numbers msn, csi_item_instances cii

132: if (p_validate_mode <> VALIDATE_ISSUE) then
133:
134:
135: select msn.gen_object_id into l_parent_object_id
136: from wip_discrete_jobs wdj, mtl_serial_numbers msn, csi_item_instances cii
137: where wdj.wip_entity_id = p_wip_entity_id
138: and wdj.maintenance_object_id = cii.instance_id
139: and wdj.maintenance_object_type = 3
140: and cii.serial_number = msn.serial_number