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_TEMPLATE_TASK_V

Object Details

Object Name:	AHL_SEARCH_TEMPLATE_TASK_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AHL.AHL_SEARCH_TEMPLATE_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
VISIT_NAME	VARCHAR2	(80)	User defined Visit's Name
TASK_ID	NUMBER		Primary Key, Unique indentifier for AHL_VISIT_TASKS_B and TL tables
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_ORGANIZATION_ID	NUMBER		Stores organization for Item to MTL_SYSTEMS_ITEMS
ITEM_NAME	VARCHAR2	(40)	Storing Concatenated Segments of the Item
MR_ROUTE_ID	NUMBER		Primary key for AHL_MR_ROUTES
MR_NAME	VARCHAR2	(80)	Stores user defined MR Title from AHL_MR_HEADERS
ROUTE_NAME	VARCHAR2	(30)	Stores user defined Route name from AHL_MR_ROUTES
TEMPLATE_FLAG	VARCHAR2	(1)	Stores boolean flag for template flag
TASK_TYPE_CODE	VARCHAR2	(30)	Storing code for task type from FND_LOOKUPS VALUES
TASK_TYPE_NAME	VARCHAR2	(80)	Storing meaning for task type from FND_LOOKUPS VALUES

Query Text

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


SELECT VISIT_ID
,      VISIT_NUMBER
,      VISIT_NAME
,      TASK_ID
,      TASK_NUMBER
,      TASK_NAME
,      ITEM_ID
,      ITEM_ORGANIZATION_ID
,      ITEM_NAME
,      MR_ROUTE_ID
,      MR_NAME
,      ROUTE_NAME
,      TEMPLATE_FLAG
,      TASK_TYPE_CODE
,      TASK_TYPE_NAME
FROM APPS.AHL_SEARCH_TEMPLATE_TASK_V;

Dependencies

[top of page]

APPS.AHL_SEARCH_TEMPLATE_TASK_V references the following:

APPS: AHL_MR_HEADERS_APP_V; AHL_MR_HEADERS_VL; AHL_MR_ROUTES_V; AHL_VISITS_VL; AHL_VISIT_TASKS_VL; FND_LOOKUP_VALUES_VL; FND_PROFILE - show dependent code; MTL_SYSTEM_ITEMS_B_KFV

APPS.AHL_SEARCH_TEMPLATE_TASK_V is not referenced by any database object