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_VISITS_VL

Object Details

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

View Type

MultiLingual view (a language resolved view of the data.)

This view stores the query to retrieve Visit information

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Id for AHL_VISITS_B and TL tables
VISIT_ID	NUMBER		Yes	Primary Key for AHL_VISITS_B and TL
VISIT_NUMBER	NUMBER	(15)	Yes	Storing Visit's Number - Autogenerated
OBJECT_VERSION_NUMBER	NUMBER		Yes	Stores locking sequence number
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
ORGANIZATION_ID	NUMBER			Foreign Key to HR_ORGANIZATION_UNITS AND MTL_PARAMETERS
DEPARTMENT_ID	NUMBER			Foreign Key to BOM_DEPARTMENTS
STATUS_CODE	VARCHAR2	(30)		Storing Visit Status Code
START_DATE_TIME	DATE			Storing Visit start date and time
VISIT_TYPE_CODE	VARCHAR2	(30)		Storing type of Visit Type Code
SIMULATION_PLAN_ID	NUMBER			Foreign Key to AHL_SIMULATION_PLANS_B and TL tables
ITEM_INSTANCE_ID	NUMBER			Install Base instance identifier
ITEM_ORGANIZATION_ID	NUMBER			Stroring Organization for item in MTL_SYSTEMS_ITEMS
INVENTORY_ITEM_ID	NUMBER			Foreign Key to MTL_SYSTEMS_ITEMS
ASSO_PRIMARY_VISIT_ID	NUMBER			Storing associated primary visit id
SIMULATION_DELETE_FLAG	VARCHAR2	(1)		Stroing boolean value for simulation delete flag
TEMPLATE_FLAG	VARCHAR2	(1)	Yes	Storing boolean value for template flag
OUT_OF_SYNC_FLAG	VARCHAR2	(1)		Storing boolean value out of sync flag
PROJECT_FLAG	VARCHAR2	(1)	Yes	Storing boolean value for project_flag
PROJECT_ID	NUMBER			Foreign Key to PA_PROJECTS_ALL
VISIT_NAME	VARCHAR2	(80)		Storing Name for Visit
DESCRIPTION	VARCHAR2	(4000)		Storing description for Visit
SERVICE_REQUEST_ID	NUMBER
SPACE_CATEGORY_CODE	VARCHAR2	(30)
CLOSE_DATE_TIME	DATE
SCHEDULE_DESIGNATOR	VARCHAR2	(10)
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment column
PRICE_LIST_ID	NUMBER
ESTIMATED_PRICE	NUMBER
ACTUAL_PRICE	NUMBER
OUTSIDE_PARTY_FLAG	VARCHAR2	(1)
ANY_TASK_CHG_FLAG	VARCHAR2	(1)
PRIORITY_CODE	VARCHAR2	(30)
PROJECT_TEMPLATE_ID	NUMBER
UNIT_SCHEDULE_ID	NUMBER
INV_LOCATOR_ID	NUMBER			Unique identifier for Inventory locator.
REQUEST_ID	NUMBER			P2P Concurrent Request Id
TOP_PROJECT_TASK_ID	NUMBER			Top Project Task Id
PAST_DATED_VISIT_FLAG	VARCHAR2	(1)		Past Dated Flag
FIRMED_FLAG	VARCHAR2	(1)		Firm Flag
LOCKED_FLAG	VARCHAR2	(1)		Lock Flag
COMP_PLANNING_LOC_ID	NUMBER			Component Planning Locator Id
COMP_INREPAIR_LOC_ID	NUMBER			Component In-Repair Locator Id
ITEM_OWNER_FLAG	VARCHAR2	(1)		Item Owner Flag
AUTO_VISIT_TYPE_FLAG	VARCHAR2	(1)		Auto Visit Type Flag

Query Text

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


SELECT ROW_ID
,      VISIT_ID
,      VISIT_NUMBER
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_ID
,      DEPARTMENT_ID
,      STATUS_CODE
,      START_DATE_TIME
,      VISIT_TYPE_CODE
,      SIMULATION_PLAN_ID
,      ITEM_INSTANCE_ID
,      ITEM_ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      ASSO_PRIMARY_VISIT_ID
,      SIMULATION_DELETE_FLAG
,      TEMPLATE_FLAG
,      OUT_OF_SYNC_FLAG
,      PROJECT_FLAG
,      PROJECT_ID
,      VISIT_NAME
,      DESCRIPTION
,      SERVICE_REQUEST_ID
,      SPACE_CATEGORY_CODE
,      CLOSE_DATE_TIME
,      SCHEDULE_DESIGNATOR
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PRICE_LIST_ID
,      ESTIMATED_PRICE
,      ACTUAL_PRICE
,      OUTSIDE_PARTY_FLAG
,      ANY_TASK_CHG_FLAG
,      PRIORITY_CODE
,      PROJECT_TEMPLATE_ID
,      UNIT_SCHEDULE_ID
,      INV_LOCATOR_ID
,      REQUEST_ID
,      TOP_PROJECT_TASK_ID
,      PAST_DATED_VISIT_FLAG
,      FIRMED_FLAG
,      LOCKED_FLAG
,      COMP_PLANNING_LOC_ID
,      COMP_INREPAIR_LOC_ID
,      ITEM_OWNER_FLAG
,      AUTO_VISIT_TYPE_FLAG
FROM APPS.AHL_VISITS_VL;

Dependencies

[top of page]

APPS.AHL_VISITS_VL references the following:

APPS: AHL_VISITS_B; AHL_VISITS_TL

APPS.AHL_VISITS_VL is referenced by following:

APPS: AHL_ALL_WORKORDERS_V; AHL_AMP_WORKBENCH_PVT - show dependent code; AHL_AVF_OPER_VSTS_PVT - show dependent code; AHL_JOB_OPER_MATERIALS_V; AHL_LTP_REQST_MATRL_PVT - show dependent code; AHL_LTP_RESRC_LEVL_PVT - show dependent code; AHL_LTP_SIMUL_PLAN_PVT - show dependent code; AHL_LTP_SPACE_ASSIGN_PVT - show dependent code; AHL_LTP_SPACE_SCHEDULE_PVT - show dependent code; AHL_MM_WRK_ORDER_RESERVTN_V; AHL_OSP_UTIL_PKG - show dependent code; AHL_PLAN_VISITS_V; AHL_PP_MATERIALS_PVT - show dependent code; AHL_PRD_DISPOSITIONS_V; AHL_PRD_DISPOSITION_PVT - show dependent code; AHL_PRD_VISITS_PVT - show dependent code; AHL_PRD_VISITS_V; AHL_RM_APPROVAL_PVT - show dependent code; AHL_SEARCH_TEMPLATES_V; AHL_SEARCH_TEMPLATE_TASK_V; AHL_SEARCH_VISITS_V; AHL_SEARCH_VISIT_TASK_V; AHL_SEARCH_WORKORDERS_V; AHL_SRH_MR_HISTORY_ALL_V; AHL_SRH_WO_HISTORY_V; AHL_VISITS_INFO_V; AHL_VISIT_DETAILS_V; AHL_VISIT_MR_V; AHL_VISIT_TASKS_V; AHL_VWP_COST_PVT - show dependent code; AHL_VWP_MR_CST_PR_PVT - show dependent code; AHL_VWP_PLAN_TASKS_PVT - show dependent code; AHL_VWP_PROJ_PROD_PVT - show dependent code; AHL_VWP_RULES_PVT - show dependent code; AHL_VWP_TASKS_LINKS_PVT - show dependent code; AHL_VWP_TASKS_PVT - show dependent code; AHL_VWP_TASK_CST_PR_PVT - show dependent code; AHL_VWP_UNPLAN_TASKS_PVT - show dependent code; AHL_VWP_VISITS_PVT - show dependent code; AHL_VWP_VISITS_STAGES_PVT - show dependent code; AHL_VWP_VISIT_CST_PR_PVT - show dependent code; AHL_WORKORDERS_V; AHL_WORKORDER_TASKS_V