[Home] [Help] [Dependency Information]
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 |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | 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) |
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;
APPS.AHL_SEARCH_VISIT_TASK_V is not referenced by any database object
|
|
|