DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.AHL_SEARCH_TEMPLATES_V

Object Details
Object Name: AHL_SEARCH_TEMPLATES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAHL.AHL_SEARCH_TEMPLATES_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
OBJECT_VERSION_NUMBER NUMBER
Yes Stores locking sequence number
TEMPLATE_FLAG VARCHAR2 (1) Yes Stores boolean values for template flag
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 Visit type Code from FND_LOOKUPS values
VISIT_TYPE_MEAN VARCHAR2 (80)
Stores Visit type Meaning from FND_LOOKUPS values
LAST_UPDATE_DATE DATE
Yes Standard Who Column
Query Text

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


SELECT VISIT_ID
,      VISIT_NUMBER
,      VISIT_NAME
,      OBJECT_VERSION_NUMBER
,      TEMPLATE_FLAG
,      INVENTORY_ITEM_ID
,      ITEM_ORGANIZATION_ID
,      ITEM_DESCRIPTION
,      VISIT_TYPE_CODE
,      VISIT_TYPE_MEAN
,      LAST_UPDATE_DATE
FROM APPS.AHL_SEARCH_TEMPLATES_V;

Dependencies

[top of page]

APPS.AHL_SEARCH_TEMPLATES_V references the following:

SchemaAPPS
ViewAHL_VISITS_VL
ViewFND_LOOKUP_VALUES_VL
ViewMTL_SYSTEM_ITEMS_B_KFV

APPS.AHL_SEARCH_TEMPLATES_V is not referenced by any database object