[Home] [Help] [Dependency Information]
Object Name: | AHL_VISIT_TASK_MATRL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AHL.AHL_VISIT_TASK_MATRL_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 identifier for visit id | ||
VISIT_TASK_ID | NUMBER | Unique identifier for visit task id | ||
VISIT_TASK_NAME | VARCHAR2 | (80) | Yes | Unique identifier for user deined visit task name |
TASK_STATUS_CODE | VARCHAR2 | (30) | ||
REQUESTED_QUANTITY | NUMBER | Yes | Identifier for requested quantity, defined in AHL_RT_OPER_MATERIALS | |
REQUESTED_DATE | DATE | Yes | Identifier for requested date, derieved based on visit task start date | |
SCHEDULED_DATE | DATE | Identifier for scheduled date | ||
SCHEDULED_QUANTITY | NUMBER | Identifier for scheduled quantity | ||
INVENTORY_ITEM_ID | NUMBER | Identifier for inventory item id, Foreign key to MTL_SYSTEM_ITEMS_B | ||
ITEM_NUMBER | VARCHAR2 | (40) | Identifier for Concatenated segments value from MTL_SYSTEM_ITEMS_KFV | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Identifier for item description value from MTL_SYSTEM_ITEMS_TL | |
UOM | VARCHAR2 | (25) | Identifier for UOM Code | |
RT_OPER_MATERIAL_ID | NUMBER | Identifier for Route Operation material id, Foreign key to AHL_RT_OPER_MATERIALS | ||
ITEM_GROUP_ID | NUMBER | Identifier for Item group id, Foreign key to AHL_ITEM_ASSOCIATIONS_B | ||
OPERATION_CODE | VARCHAR2 | (80) | Identifier for Operation code | |
OPERATION_SEQUENCE | NUMBER | Identifier for Operation sequence, Derieved from AHL_ROUTE_OPERATIONS | ||
SCHEDULE_MATERIAL_ID | NUMBER | Yes | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | Identifier for object version number | |
POSITION_PATH_ID | NUMBER | Identifier for mc path position id | ||
POSITION_PATH | VARCHAR2 | (4000) | Identifier for mc path position | |
RELATIONSHIP_ID | NUMBER | Identifier for mc relationship id | ||
NAME | VARCHAR2 | (80) | Identifier for MC Subconfiguration | |
REWORK_PERCENT | NUMBER | Identifier for item rework percent | ||
REPLACE_PERCENT | NUMBER | Identifier for item replace percent | ||
ITEM_COMP_DETAIL_ID | NUMBER | Identifier for item composition | ||
SALES_ORDER_LINE_ID | VARCHAR2 | (163) | Identifier for sales order line id | |
MAT_STATUS | VARCHAR2 | (30) | Status of the Material |
Cut, paste (and edit) the following text to query this object:
SELECT VISIT_ID
, VISIT_TASK_ID
, VISIT_TASK_NAME
, TASK_STATUS_CODE
, REQUESTED_QUANTITY
, REQUESTED_DATE
, SCHEDULED_DATE
, SCHEDULED_QUANTITY
, INVENTORY_ITEM_ID
, ITEM_NUMBER
, ITEM_DESCRIPTION
, UOM
, RT_OPER_MATERIAL_ID
, ITEM_GROUP_ID
, OPERATION_CODE
, OPERATION_SEQUENCE
, SCHEDULE_MATERIAL_ID
, OBJECT_VERSION_NUMBER
, POSITION_PATH_ID
, POSITION_PATH
, RELATIONSHIP_ID
, NAME
, REWORK_PERCENT
, REPLACE_PERCENT
, ITEM_COMP_DETAIL_ID
, SALES_ORDER_LINE_ID
, MAT_STATUS
FROM APPS.AHL_VISIT_TASK_MATRL_V;
|
|
|