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_VISIT_DETAILS_V

Object Details

Object Name:	AHL_VISIT_DETAILS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AHL.AHL_VISIT_DETAILS_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
ASSO_PRIMARY_VISIT_ID	NUMBER			Foreign key to AHL_VISITS_B and TL, Associated Primary Visit ID
PRIMARY_VISIT_NUMBER	NUMBER			Associated Primary Visit Number
ORG_ID	NUMBER			Foreign Key to HR_ORGANIZATION_UNITS AND MTL_PARAMETERS
ORG_CODE	VARCHAR2	(3)		Organization Code
ORG_NAME	VARCHAR2	(240)		Organization Name for Org Id from HR_ORGANIZATION_UNITS AND MTL_PARAMETERS
DEPT_ID	NUMBER			Foreign Key to BOM_DEPARTMENTS
DEPT_CODE	VARCHAR2	(10)		Department Code
DEPT_DESCRIPTION	VARCHAR2	(240)		Departemnt Description for Dept id in bom_departments
OBJECT_VERSION_NUMBER	NUMBER		Yes	Stores Locking sequence number
START_DATE_TIME	DATE			Storing the Start date and time of a Visit
END_DATE	VARCHAR2	(0)		Storing the End date and time of a Visit
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			Organization to which Item belongs
ITEM_DESCRIPTION	VARCHAR2	(40)		Storing Concatenated Segments of the Item
VISIT_TYPE_CODE	VARCHAR2	(30)		Storing type of Visit Code
VISIT_TYPE_MEAN	VARCHAR2	(80)		Storing type of Visit Code
SIMULATION_DELETE_FLAG	VARCHAR2	(1)		Storing value of simulation flag
SIMULATION_DELETE_MEAN	VARCHAR2	(80)		Storing meaning of simulation flag
SIMULATION_PLAN_ID	NUMBER			Foreign Key to AHL_SIMULATION_PLANS_B and TL tables
SIMULATION_PLAN_NAME	VARCHAR2	(80)		Storing simuaiton plan name for simulation plan id
DUE_BY	DATE			Storing Due by frrm AHL_UNIT_EFFECTIVITIES_B table
PLANNED_END_DATE	DATE			Identifier for planned end date
SPACE_CATEGORY_CODE	VARCHAR2	(30)		Identifier for space category code
SPACE_CATEGORY_MEAN	VARCHAR2	(80)		Identifier for space category mean
UNIT_NAME	VARCHAR2	(4000)		Identifier for unit config name
STATUS_CODE	VARCHAR2	(30)		Identifier for visit status code
STATUS_MEAN	VARCHAR2	(80)		Identifier for visit status meaning

Query Text

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


SELECT VISIT_ID
,      VISIT_NUMBER
,      VISIT_NAME
,      ASSO_PRIMARY_VISIT_ID
,      PRIMARY_VISIT_NUMBER
,      ORG_ID
,      ORG_CODE
,      ORG_NAME
,      DEPT_ID
,      DEPT_CODE
,      DEPT_DESCRIPTION
,      OBJECT_VERSION_NUMBER
,      START_DATE_TIME
,      END_DATE
,      ITEM_INSTANCE_ID
,      SERIAL_NUMBER
,      INVENTORY_ITEM_ID
,      ITEM_ORGANIZATION_ID
,      ITEM_DESCRIPTION
,      VISIT_TYPE_CODE
,      VISIT_TYPE_MEAN
,      SIMULATION_DELETE_FLAG
,      SIMULATION_DELETE_MEAN
,      SIMULATION_PLAN_ID
,      SIMULATION_PLAN_NAME
,      DUE_BY
,      PLANNED_END_DATE
,      SPACE_CATEGORY_CODE
,      SPACE_CATEGORY_MEAN
,      UNIT_NAME
,      STATUS_CODE
,      STATUS_MEAN
FROM APPS.AHL_VISIT_DETAILS_V;

Dependencies

[top of page]

APPS.AHL_VISIT_DETAILS_V references the following:

APPS: AHL_SIMULATION_PLANS_VL; AHL_UNIT_EFFECTIVITIES_B; AHL_UTILITY_PVT - show dependent code; AHL_VISITS_VL; AHL_VISIT_TASKS_B; BOM_DEPARTMENTS; CSI_ITEM_INSTANCES; FND_LOOKUP_VALUES_VL; HR_ALL_ORGANIZATION_UNITS; HR_GENERAL - show dependent code; HR_SECURITY - show dependent code; MO_GLOBAL - show dependent code; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_B_KFV; ORG_ORGANIZATION_DEFINITIONS

APPS.AHL_VISIT_DETAILS_V is referenced by following:

APPS: AHL_LTP_SPACE_SCHEDULE_PVT - show dependent code