DBA Data[Home] [Help]

APPS.EAM_PROCESS_FAILURE_ENTRY_PUB dependencies on WIP_ENTITIES

Line 158: FROM wip_entities

154: IF l_eam_failure_entry_record.source_id IS NULL THEN
155: BEGIN
156: SELECT wip_entity_id
157: INTO l_eam_failure_entry_record.source_id
158: FROM wip_entities
159: WHERE wip_entity_name = l_eam_failure_entry_record.source_name
160: AND organization_id = l_eam_failure_entry_record.maint_organization_id
161: AND entity_type in (6,7);
162: EXCEPTION

Line 337: FROM WIP_ENTITIES

333: SELECT failure_id
334: INTO l_eam_failure_entry_record.failure_id
335: FROM eam_asset_failures
336: WHERE source_id = ( SELECT wip_entity_id
337: FROM WIP_ENTITIES
338: WHERE WIP_ENTITY_NAME = l_eam_failure_entry_record.source_name
339: AND organization_id = l_eam_failure_entry_record.maint_organization_id
340: )
341: AND source_type = 1;