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_PRD_VISITS_V

Object Details

Object Name:	AHL_PRD_VISITS_V
Object Type:	VIEW
Owner:	APPS
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
OBJECT_VERSION_NUMBER	NUMBER		Yes	Stores locking sequence number
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
START_DATE_TIME	DATE			Stores Visit Start date and time
CLOSE_DATE_TIME	DATE			Stores Visit End date and time
SCHEDULED_START_DATE	DATE		Yes	Stores Workorder scheduled start date and time
SCHEDULED_END_DATE	DATE		Yes	Stores Workorder scheduled end date and time
ACTUAL_START_DATE	DATE			Stores Workorder actual start date and time
ACTUAL_END_DATE	DATE			Stores Workorder actual end date and time
STATUS_CODE	VARCHAR2	(30)		Storing visit status code from FND_LOOKUPS
STATUS	VARCHAR2	(80)		status meaning
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	VARCHAR2	(80)		Stores Meaning from FND_LOOKUPS for Visit Type
UNIT_NAME	VARCHAR2	(4000)		Unit Name derived from the unit id
UNIT_LOCKED_FLAG	VARCHAR2	(4000)		Indicates if the Unit is quarantined.
INV_LOCATOR_ID	NUMBER			Identifier for Visit Locator.
SUBINVENTORY	VARCHAR2	(10)		Visit Subinventory
LOCATOR_SEGMENTS	VARCHAR2	(4000)		Visit Locator concatenated segments.
FILE_LOCATION	VARCHAR2	(4000)		Job card relative path and file name.
JOB_CARD_EXISTS	VARCHAR2	(4000)		Indicator if generated work card exists.
LATEST_JC_STATUS	VARCHAR2	(4000)		Status of the most recent (in progress) work card request.
JOB_CARD_ERROR_MSG	VARCHAR2	(4000)		Error message when work card generation fails.

Query Text

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


SELECT VISIT_ID
,      OBJECT_VERSION_NUMBER
,      VISIT_NUMBER
,      VISIT_NAME
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      DEPARTMENT_ID
,      DEPARTMENT_NAME
,      START_DATE_TIME
,      CLOSE_DATE_TIME
,      SCHEDULED_START_DATE
,      SCHEDULED_END_DATE
,      ACTUAL_START_DATE
,      ACTUAL_END_DATE
,      STATUS_CODE
,      STATUS
,      ITEM_INSTANCE_ID
,      SERIAL_NUMBER
,      INVENTORY_ITEM_ID
,      ITEM_ORGANIZATION_ID
,      ITEM_DESCRIPTION
,      VISIT_TYPE_CODE
,      VISIT_TYPE
,      UNIT_NAME
,      UNIT_LOCKED_FLAG
,      INV_LOCATOR_ID
,      SUBINVENTORY
,      LOCATOR_SEGMENTS
,      FILE_LOCATION
,      JOB_CARD_EXISTS
,      LATEST_JC_STATUS
,      JOB_CARD_ERROR_MSG
FROM APPS.AHL_PRD_VISITS_V;