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

TABLE: AHL.AHL_VISIT_TASKS_B

Object Details
Object Name: AHL_VISIT_TASKS_B
Object Type: TABLE
Owner: AHL
FND Design Data: TableAHL.AHL_VISIT_TASKS_B
Subobject Name:
Status: VALID


This table stores information about visit tasks


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AHL_VISIT_TASKS_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnVISIT_TASK_ID
AHL_VISIT_TASKS_B_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnVISIT_ID
ColumnVISIT_TASK_NUMBER
AHL_VISIT_TASKS_B_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMR_ID
AHL_VISIT_TASKS_B_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUNIT_EFFECTIVITY_ID
AHL_VISIT_TASKS_B_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINSTANCE_ID
AHL_VISIT_TASKS_B_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVENTORY_ITEM_ID
ColumnITEM_ORGANIZATION_ID
AHL_VISIT_TASKS_B_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORIGINATING_TASK_ID
Columns
Name Datatype Length Mandatory Comments
VISIT_TASK_ID NUMBER
Yes Primary key for table AHL_VISIT_TASKS_B
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
VISIT_ID NUMBER
Yes Foreign key to AHL_VISITS_B and TL tables
PROJECT_TASK_ID NUMBER

Foreign Key to PA_TASKS, Unique identifier for tasks created in Projects
COST_PARENT_ID NUMBER

A visit task which is defined as cost parent of this task
MR_ROUTE_ID NUMBER

Foreign Key to AHL_MR_ROUTES
MR_ID NUMBER

Foreign Key to AHL_MR_HEADERS_B
DURATION NUMBER

User defined Visit's Task Duration
UNIT_EFFECTIVITY_ID NUMBER

Foreign Key for a Unit or item instance Effectivity.
START_FROM_HOUR NUMBER

User defined Start form hour for Task
INVENTORY_ITEM_ID NUMBER
Yes Foreign Key to MTL_SYSTEMS_ITEMS
INSTANCE_ID NUMBER

Install Base instance identifier
PRIMARY_VISIT_TASK_ID NUMBER

Primary Visit Task ID
SUMMARY_TASK_FLAG VARCHAR2 (1) Yes To check whether the task created is a Summary or Other Tasks
ORIGINATING_TASK_ID NUMBER

Visit Task ID stored as Originating Task ID
VISIT_TASK_NUMBER NUMBER (15) Yes Autogenerated Visit Task Number
ITEM_ORGANIZATION_ID NUMBER
Yes Organization for Item
SERVICE_REQUEST_ID NUMBER

Foreign Key to CS_INCIDENTS_ALL_B
TASK_TYPE_CODE VARCHAR2 (30) Yes Stroing the type of task code
SECURITY_GROUP_ID NUMBER

Used in application hosting
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
DEPARTMENT_ID NUMBER

Department ID
STATUS_CODE VARCHAR2 (30)
Status Code
ESTIMATED_PRICE NUMBER

Estimated Price
ACTUAL_PRICE NUMBER

Actual Price
PRICE_LIST_ID NUMBER

Price List Id
ACTUAL_COST NUMBER

Actual cost
STAGE_ID NUMBER

STAGE_ID
START_DATE_TIME DATE

Calculated task actual start time
END_DATE_TIME DATE

Calculated task actual end time
QUANTITY NUMBER

Task Quantity
PAST_TASK_START_DATE DATE

Past task start date
PAST_TASK_END_DATE DATE

Past task end date
SERVICE_TYPE_CODE VARCHAR2 (30)
Service Type Code
ORIGINATING_MR_HEADER_ID NUMBER

Originating MR Header Id for Non Routines
STAGE_TYPE_CODE VARCHAR2 (30)
Task's Stage Type Code
RETURN_TO_SUPPLY_FLAG VARCHAR2 (1)
Return to Supply Indicator.
REPAIR_BATCH_NAME VARCHAR2 (240)
Repair Batch Concatenated Name
TARGET_QTY NUMBER

Repair Quantity for the Batch
RET_SERVICEABLE_QTY NUMBER

Serviceable Quantity returned form the Batch
RET_UNSERVICEABLE_QTY NUMBER

Unserviceable Quantity returned from the Batch.
Query Text

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


SELECT VISIT_TASK_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      VISIT_ID
,      PROJECT_TASK_ID
,      COST_PARENT_ID
,      MR_ROUTE_ID
,      MR_ID
,      DURATION
,      UNIT_EFFECTIVITY_ID
,      START_FROM_HOUR
,      INVENTORY_ITEM_ID
,      INSTANCE_ID
,      PRIMARY_VISIT_TASK_ID
,      SUMMARY_TASK_FLAG
,      ORIGINATING_TASK_ID
,      VISIT_TASK_NUMBER
,      ITEM_ORGANIZATION_ID
,      SERVICE_REQUEST_ID
,      TASK_TYPE_CODE
,      SECURITY_GROUP_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DEPARTMENT_ID
,      STATUS_CODE
,      ESTIMATED_PRICE
,      ACTUAL_PRICE
,      PRICE_LIST_ID
,      ACTUAL_COST
,      STAGE_ID
,      START_DATE_TIME
,      END_DATE_TIME
,      QUANTITY
,      PAST_TASK_START_DATE
,      PAST_TASK_END_DATE
,      SERVICE_TYPE_CODE
,      ORIGINATING_MR_HEADER_ID
,      STAGE_TYPE_CODE
,      RETURN_TO_SUPPLY_FLAG
,      REPAIR_BATCH_NAME
,      TARGET_QTY
,      RET_SERVICEABLE_QTY
,      RET_UNSERVICEABLE_QTY
FROM AHL.AHL_VISIT_TASKS_B;

Dependencies

[top of page]

AHL.AHL_VISIT_TASKS_B does not reference any database object

AHL.AHL_VISIT_TASKS_B is referenced by following:

SchemaAHL
ViewAHL_VISIT_TASKS_B#