[Home] [Help] [Dependency Information]
Object Name: | AHL_SCHEDULE_MATERIALS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AHL.AHL_SCHEDULE_MATERIALS_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 |
---|---|---|---|---|
WORKORDER_ID | NUMBER | Yes | Identifier for Workorder id | |
VISIT_TASK_ID | NUMBER | Identifier for visit task ID, Foreign key to AHL_VISIT_TASKS_B table. | ||
WO_NAME | VARCHAR2 | (80) | Yes | Identifier for job description |
SCHEDULE_MATERIAL_ID | NUMBER | Yes | Identifier for scheduled material id. | |
INVENTORY_ITEM_ID | NUMBER | Identifier for inventory id. Foreign key to MTL_SYSTEM_ITEMS_B | ||
CONCATENATED_SEGMENTS | VARCHAR2 | (40) | Identifier for concatenated segments | |
UOM_CODE | VARCHAR2 | (3) | Identifier for primary uom code | |
UOM | VARCHAR2 | (25) | Identifier for Unit of measure | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Stores locking sequence number | |
ITEM_GROUP_ID | NUMBER | Identifier for alternate parts | ||
RT_OPER_MATERIAL_ID | NUMBER | Identifier for Route oper material id | ||
VISIT_ID | NUMBER | Identifier for visit id. Foreign key to AHL_VISITS_B | ||
REQUESTED_DATE | DATE | Identifier for requested date | ||
REQUESTED_QUANTITY | NUMBER | Yes | Identifier for requested quantity | |
SCHEDULE_DATE | DATE | Identifier for schedule date | ||
SCHEDULE_QUANTITY | NUMBER | Identifier for schedule quantity | ||
WORKORDER_OPERATION_ID | NUMBER | Identifier for workorder operation | ||
OPERATION_SEQUENCE | NUMBER | Identifier for operation sequence | ||
PRIORITY | NUMBER | Identifier for priority | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | Identifier for organization name |
DEPARTMENT_NAME | VARCHAR2 | (240) | Identifier for department name | |
SERVICE_REQUEST | VARCHAR2 | (64) | Identifier for service request | |
VISIT_NUMBER | NUMBER | (15) | Yes | Identifier for visit number |
ISSUED_QUANTITY | NUMBER | Identifier for issued quantity | ||
JOB_STATUS_CODE | VARCHAR2 | (30) | Yes | Identifier for job status code |
JOB_STATUS_MEANING | VARCHAR2 | (80) | Identifier for job status meaning | |
SALES_ORDER_LINE_ID | NUMBER | Yes | Identifier for sales order line id | |
UNIT_LOCKED_FLAG | VARCHAR2 | (4000) | Indicates if the Unit is quarantined. | |
RESERVED_QUANTITY | NUMBER | Total number of Serial Numbers reserved. | ||
IN_SERVICE | VARCHAR2 | (1) | Flag to indicate whether the item is repair item or not. | |
NET_QUANTITY | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT WORKORDER_ID
, VISIT_TASK_ID
, WO_NAME
, SCHEDULE_MATERIAL_ID
, INVENTORY_ITEM_ID
, CONCATENATED_SEGMENTS
, UOM_CODE
, UOM
, OBJECT_VERSION_NUMBER
, ITEM_GROUP_ID
, RT_OPER_MATERIAL_ID
, VISIT_ID
, REQUESTED_DATE
, REQUESTED_QUANTITY
, SCHEDULE_DATE
, SCHEDULE_QUANTITY
, WORKORDER_OPERATION_ID
, OPERATION_SEQUENCE
, PRIORITY
, ORGANIZATION_NAME
, DEPARTMENT_NAME
, SERVICE_REQUEST
, VISIT_NUMBER
, ISSUED_QUANTITY
, JOB_STATUS_CODE
, JOB_STATUS_MEANING
, SALES_ORDER_LINE_ID
, UNIT_LOCKED_FLAG
, RESERVED_QUANTITY
, IN_SERVICE
, NET_QUANTITY
FROM APPS.AHL_SCHEDULE_MATERIALS_V;
APPS.AHL_SCHEDULE_MATERIALS_V is not referenced by any database object
|
|
|