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_VISIT_TASK_V

Object Details

Object Name:	AHL_SEARCH_VISIT_TASK_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AHL.AHL_SEARCH_VISIT_TASK_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	Comments
VISIT_ID	NUMBER		Primary Key, Unique indentifier for AHL_VISITS_B and TL tables
VISIT_NUMBER	NUMBER	(15)	Unique identifier of a Visit - Auotgenerated
TEMPLATE_FLAG	VARCHAR2	(1)	Stores boolean values for template flag
VISIT_STATUS_CODE	VARCHAR2	(30)	Storing visit status code from FND_LOOKUPS
TASK_ID	NUMBER		Primary Key, Unique Indentifier of a Visit Task
TASK_NUMBER	NUMBER	(15)	Unique identifier of a Task - Auotgenerated
TASK_NAME	VARCHAR2	(80)	User defined Visit task's name
ITEM_ID	NUMBER		Foreign Key to MTL_SYSTEMS_ITEMS
ITEM_NAME	VARCHAR2	(40)	Storing Concatenated Segments of the Item
ITEM_ORGANIZATION_ID	NUMBER		Stores organization for Item to MTL_SYSTEMS_ITEMSStores organization for Item to MTL_SYSTEMS_ITEMS
UNIT_ID	NUMBER		Install Base instance identifier
UNIT_NAME	VARCHAR2	(30)	Stores Serial Number for Install Base instance identifier
MR_ROUTE_ID	NUMBER		Foreign Key to AHL_MR_ROUTES
MR_NAME	VARCHAR2	(80)	User defined name for MR
ROUTE_NAME	VARCHAR2	(30)	User defined for Route name
ROUTE_TYPE_CODE	VARCHAR2	(30)
ROUTE_TYPE	VARCHAR2	(80)
WORK_ORDER_ID	NUMBER		Foreign Key to AHL_WORKORDERS
WORKORDER_NAME	VARCHAR2	(80)	User defined work order name
WORKORDER_STATUS	VARCHAR2	(30)	Stores Workorder status code from FND_LOOKUPS
WORKORDER_STATUS_MEANING	VARCHAR2	(80)	Workorder Status
WORKORDER_START_DATE	DATE
WORKORDER_END_DATE	DATE
SERVICE_REQ_ID	NUMBER		Foreign Key to CS_INCIDENTS_ALL_B
SERVICE_REQ_NAME	VARCHAR2	(64)	Stores user defined Service request name
START_DATE_TIME	DATE		Storing Task start date and time calculated on the basis of visit to which task belongs
END_DATE_TIME	DATE		Storing Task End date and time calculated on the basis of visit to which task belongs
TASK_TYPE_CODE	VARCHAR2	(30)	Stores code for Task Type from FND_LOOKUPS
TASK_TYPE_NAME	VARCHAR2	(80)	Stores meaning for Task Type from FND_LOOKUPS
TASK_STATUS_CODE	VARCHAR2	(30)
TASK_STATUS_NAME	VARCHAR2	(80)
STAGE_ID	NUMBER
STAGE_NUM	NUMBER
STAGE_NAME	VARCHAR2	(80)
DUE_BY_DATE	DATE		Stores due date from AHL_UNIT_EFFECTIVITIES table
DEPARTMENT_ID	NUMBER
DEPARTMENT_NAME	VARCHAR2	(240)
ORIGINATING_TASK_ID	NUMBER
ORIGINATING_TASK_NUMBER	NUMBER	(15)
ORIGINATING_TASK_NAME	VARCHAR2	(80)
MR_ID	NUMBER		MRId
UNIT_EFFECTIVITY_ID	NUMBER		UnitEffectivityId
MR_DESCRIPTION	VARCHAR2	(2000)	Description
QUANTITY	NUMBER		Task Quantity
UOM	VARCHAR2	(3)	Unit of Measure
INSTANCE_NUMBER	VARCHAR2	(30)	Instance Number
SERVICE_TYPE_CODE	VARCHAR2	(30)
SERVICE_TYPE	VARCHAR2	(80)
WARRANTY_ENTITLEMENT_ID	NUMBER
CONTRACT_NUMBER	NUMBER
ENTITLEMENT_STATUS_CODE	VARCHAR2	(30)
ENTITLEMENT_STATUS	VARCHAR2	(80)
CLAIM_NAME	VARCHAR2	(30)
CLAIM_STATUS_CODE	VARCHAR2	(30)
CLAIM_STATUS	VARCHAR2	(80)
TASK_WARRANTY_FLAG	VARCHAR2	(4000)
INSTANCE_WARRANTY_FLAG	VARCHAR2	(4000)
WARRANTY_NOT_APPL_FLAG	VARCHAR2	(1)

Query Text

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


SELECT VISIT_ID
,      VISIT_NUMBER
,      TEMPLATE_FLAG
,      VISIT_STATUS_CODE
,      TASK_ID
,      TASK_NUMBER
,      TASK_NAME
,      ITEM_ID
,      ITEM_NAME
,      ITEM_ORGANIZATION_ID
,      UNIT_ID
,      UNIT_NAME
,      MR_ROUTE_ID
,      MR_NAME
,      ROUTE_NAME
,      ROUTE_TYPE_CODE
,      ROUTE_TYPE
,      WORK_ORDER_ID
,      WORKORDER_NAME
,      WORKORDER_STATUS
,      WORKORDER_STATUS_MEANING
,      WORKORDER_START_DATE
,      WORKORDER_END_DATE
,      SERVICE_REQ_ID
,      SERVICE_REQ_NAME
,      START_DATE_TIME
,      END_DATE_TIME
,      TASK_TYPE_CODE
,      TASK_TYPE_NAME
,      TASK_STATUS_CODE
,      TASK_STATUS_NAME
,      STAGE_ID
,      STAGE_NUM
,      STAGE_NAME
,      DUE_BY_DATE
,      DEPARTMENT_ID
,      DEPARTMENT_NAME
,      ORIGINATING_TASK_ID
,      ORIGINATING_TASK_NUMBER
,      ORIGINATING_TASK_NAME
,      MR_ID
,      UNIT_EFFECTIVITY_ID
,      MR_DESCRIPTION
,      QUANTITY
,      UOM
,      INSTANCE_NUMBER
,      SERVICE_TYPE_CODE
,      SERVICE_TYPE
,      WARRANTY_ENTITLEMENT_ID
,      CONTRACT_NUMBER
,      ENTITLEMENT_STATUS_CODE
,      ENTITLEMENT_STATUS
,      CLAIM_NAME
,      CLAIM_STATUS_CODE
,      CLAIM_STATUS
,      TASK_WARRANTY_FLAG
,      INSTANCE_WARRANTY_FLAG
,      WARRANTY_NOT_APPL_FLAG
FROM APPS.AHL_SEARCH_VISIT_TASK_V;

Dependencies

[top of page]

APPS.AHL_SEARCH_VISIT_TASK_V references the following:

APPS: AHL_MR_HEADERS_VL; AHL_MR_ROUTES_V; AHL_ROUTES_B; AHL_UNIT_EFFECTIVITIES_B; AHL_VISITS_VL; AHL_VISIT_TASKS_VL; AHL_VWP_STAGES_VL; AHL_WARRANTY_CLAIMS_B; AHL_WARRANTY_CONTRACTS_B; AHL_WARRANTY_CONTRACTS_PVT - show dependent code; AHL_WARRANTY_ENTITLEMENTS; AHL_WARRANTY_ENTL_PVT - show dependent code; AHL_WORKORDERS; BOM_DEPARTMENTS; CSI_ITEM_INSTANCES; CS_INCIDENTS_ALL_B; FND_LOOKUP_VALUES_VL; FND_PROFILE - show dependent code; MTL_SYSTEM_ITEMS_B_KFV; PA_LOOKUPS

APPS.AHL_SEARCH_VISIT_TASK_V is not referenced by any database object