[Home] [Help] [Dependency Information]
Object Name: | AHL_MATERIAL_REQUIREMENTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
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 | |||
VISIT_TASK_ID | NUMBER | |||
VISIT_TASK_NUMBER | NUMBER | (15) | Yes | |
TASK_STATUS_CODE | VARCHAR2 | (30) | ||
VISIT_NUMBER | NUMBER | (15) | Yes | |
VISIT_TYPE_CODE | VARCHAR2 | (30) | ||
VISIT_TYPE_MEAN | VARCHAR2 | (80) | ||
VISIT_STATUS_CODE | VARCHAR2 | (30) | ||
VISIT_STATUS_MEAN | VARCHAR2 | (80) | ||
REQUESTED_QUANTITY | NUMBER | Yes | ||
REQUESTED_DATE | DATE | Yes | ||
EXCEPTION_DATE | DATE | |||
SCHEDULED_QUANTITY | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | |||
ITEM_DESCRIPTION | VARCHAR2 | (40) | ||
TRACKABLE_FLAG | VARCHAR2 | (1) | ||
SERIAL_CONTROL_FLAG | VARCHAR2 | (1) | ||
ORGANIZATION_ID | NUMBER | |||
ORGANIZATION_NAME | VARCHAR2 | (240) | ||
UOM | VARCHAR2 | (25) | ||
SCHEDULE_MATERIAL_ID | NUMBER | Yes | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
REWORK_PERCENT | NUMBER | |||
REPLACE_PERCENT | NUMBER | |||
WORKORDER_NUMBER | VARCHAR2 | (80) | ||
RESERVED_QUANTITY | NUMBER | |||
RT_OPER_MATERIAL_ID | NUMBER | |||
WORKORDER_OPERATION_ID | NUMBER | |||
ITEM_GROUP_ID | NUMBER | |||
POSITION_PATH_ID | NUMBER | |||
RELATIONSHIP_ID | NUMBER | |||
SUBCONFIG_NAME | VARCHAR2 | (80) | ||
MR_TITLE | VARCHAR2 | (80) | ||
ROUTE_NUMBER | VARCHAR2 | (30) | ||
ROUTE_TITLE | VARCHAR2 | (240) | ||
OPERATION_SEQ_NUM | NUMBER | |||
COMPLETED_QUANTITY | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT VISIT_ID
, VISIT_TASK_ID
, VISIT_TASK_NUMBER
, TASK_STATUS_CODE
, VISIT_NUMBER
, VISIT_TYPE_CODE
, VISIT_TYPE_MEAN
, VISIT_STATUS_CODE
, VISIT_STATUS_MEAN
, REQUESTED_QUANTITY
, REQUESTED_DATE
, EXCEPTION_DATE
, SCHEDULED_QUANTITY
, INVENTORY_ITEM_ID
, ITEM_DESCRIPTION
, TRACKABLE_FLAG
, SERIAL_CONTROL_FLAG
, ORGANIZATION_ID
, ORGANIZATION_NAME
, UOM
, SCHEDULE_MATERIAL_ID
, OBJECT_VERSION_NUMBER
, REWORK_PERCENT
, REPLACE_PERCENT
, WORKORDER_NUMBER
, RESERVED_QUANTITY
, RT_OPER_MATERIAL_ID
, WORKORDER_OPERATION_ID
, ITEM_GROUP_ID
, POSITION_PATH_ID
, RELATIONSHIP_ID
, SUBCONFIG_NAME
, MR_TITLE
, ROUTE_NUMBER
, ROUTE_TITLE
, OPERATION_SEQ_NUM
, COMPLETED_QUANTITY
FROM APPS.AHL_MATERIAL_REQUIREMENTS_V;
|
|
|