eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.AHL_SEARCH_VISITS_V

Object Details

Object Name:	AHL_SEARCH_VISITS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AHL.AHL_SEARCH_VISITS_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
VISIT_ID	NUMBER		Yes	Primary Key, Unique indentifier for AHL_VISITS_B and TL tables
VISIT_NUMBER	NUMBER	(15)	Yes	Unique identifier of a Visit - Auotgenerated
VISIT_NAME	VARCHAR2	(80)		User defined Visit's Name
ORGANIZATION_ID	NUMBER			Foreign Key to HR_ORGANIZATION_UNITS AND MTL_PARAMETERS
ORGANIZATION_NAME	VARCHAR2	(240)		Organization Name for Org Id from HR_ORGANIZATION_UNITS AND MTL_PARAMETERS
DEPARTMENT_ID	NUMBER			Foreign Key to BOM_DEPARTMENTS
DEPARTMENT_NAME	VARCHAR2	(240)		Departemnt Description for Dept id in bom_departments
OBJECT_VERSION_NUMBER	NUMBER		Yes	Stores locking sequence number
START_DATE_TIME	DATE			Stores Visit Start date and time
STATUS_CODE	VARCHAR2	(30)		Storing visit status code from FND_LOOKUPS
STATUS_MEAN	VARCHAR2	(80)		status meaning
TEMPLATE_FLAG	VARCHAR2	(1)	Yes	Stores boolean value for template flag
ITEM_INSTANCE_ID	NUMBER			Install Base instance identifier
SERIAL_NUMBER	VARCHAR2	(30)		Storing Serial Number for Install Base instance identifier
INVENTORY_ITEM_ID	NUMBER			Foreign Key to MTL_SYSTEMS_ITEMS
ITEM_ORGANIZATION_ID	NUMBER			Stores organization for Item to MTL_SYSTEMS_ITEMS
ITEM_DESCRIPTION	VARCHAR2	(40)		Storing Concatenated Segments of the Item
VISIT_TYPE_CODE	VARCHAR2	(30)		Stores Code from FND_LOOKUPS for Visit Type
VISIT_TYPE_MEAN	VARCHAR2	(80)		Stores Meaning from FND_LOOKUPS for Visit Type
SIMULATION_PLAN_ID	NUMBER			Foreign Key to AHL_SIMULATION_PLANS_B and TL tables
SIMULATION_PLAN_NAME	VARCHAR2	(80)		Storing simulation plan name for simulation plan id
PRIMARY_PLAN_FLAG	VARCHAR2	(1)		Stores boolean value for the Primary Plan
SPACE_CATEGORY_CODE	VARCHAR2	(30)
SPACE_CATEGORY_MEAN	VARCHAR2	(80)
SERVICE_REQUEST_ID	NUMBER
CLOSE_DATE_TIME	DATE
INCIDENT_NUMBER	VARCHAR2	(64)
UNIT_NAME	VARCHAR2	(80)
PRIORITY_CODE	VARCHAR2	(30)
PRIORITY_MEAN	VARCHAR2	(80)
PROJECT_TEMPLATE_ID	NUMBER
UNIT_SCHEDULE_ID	NUMBER
PROJECT_TEMPLATE_NAME	VARCHAR2	(30)		Project Template's Name
ASSO_PRIMARY_VISIT_ID	NUMBER
CP_REQUEST	VARCHAR2	(121)		P2P Concurrent Request Status
PAST_DATED_VISIT_FLAG	VARCHAR2	(1)		Past Dated Visit Flag

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT VISIT_ID
,      VISIT_NUMBER
,      VISIT_NAME
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      DEPARTMENT_ID
,      DEPARTMENT_NAME
,      OBJECT_VERSION_NUMBER
,      START_DATE_TIME
,      STATUS_CODE
,      STATUS_MEAN
,      TEMPLATE_FLAG
,      ITEM_INSTANCE_ID
,      SERIAL_NUMBER
,      INVENTORY_ITEM_ID
,      ITEM_ORGANIZATION_ID
,      ITEM_DESCRIPTION
,      VISIT_TYPE_CODE
,      VISIT_TYPE_MEAN
,      SIMULATION_PLAN_ID
,      SIMULATION_PLAN_NAME
,      PRIMARY_PLAN_FLAG
,      SPACE_CATEGORY_CODE
,      SPACE_CATEGORY_MEAN
,      SERVICE_REQUEST_ID
,      CLOSE_DATE_TIME
,      INCIDENT_NUMBER
,      UNIT_NAME
,      PRIORITY_CODE
,      PRIORITY_MEAN
,      PROJECT_TEMPLATE_ID
,      UNIT_SCHEDULE_ID
,      PROJECT_TEMPLATE_NAME
,      ASSO_PRIMARY_VISIT_ID
,      CP_REQUEST
,      PAST_DATED_VISIT_FLAG
FROM APPS.AHL_SEARCH_VISITS_V;

Dependencies

[top of page]

APPS.AHL_SEARCH_VISITS_V references the following:

APPS: AHL_SIMULATION_PLANS_VL; AHL_UNIT_CONFIG_HEADERS; AHL_VISITS_VL; BOM_DEPARTMENTS; CSI_ITEM_INSTANCES; CS_INCIDENTS_ALL_B; FND_CONCURRENT_REQUESTS; FND_GLOBAL - show dependent code; FND_LOOKUPS; FND_LOOKUP_VALUES_VL; HR_ALL_ORGANIZATION_UNITS; HR_GENERAL - show dependent code; HR_SECURITY - show dependent code; MO_GLOBAL - show dependent code; MTL_SYSTEM_ITEMS_B_KFV; ORG_ORGANIZATION_DEFINITIONS; PA_PROJECTS

APPS.AHL_SEARCH_VISITS_V is not referenced by any database object