[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AHL_RT_OPER_MATERIALS |
|---|---|
| Object Type: | TABLE |
| Owner: | AHL |
| FND Design Data: |  AHL.AHL_RT_OPER_MATERIALS
|
| Subobject Name: | |
| Status: | VALID |
This table stores the material and tool requirements for a Route or an Operation. The attribute ASSOCIATION_TYPE stores the type of association namely Route or Operation. The attribute OBJECT_ID stores the identifier of the Route or Operation. The attribute REC_TYPE stores the information which denotes whether the record stores material or tool requirements. If the status of an Operation or Route is Current and any of the attributes of the current record are changed, the previous version of the record is copied to a history table AHL_RT_OPER_MATERIALS_H and the revision number is incremented.
| Tablespace: |  APPS_TS_SEED |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AHL_RT_OPER_MATERIALS_U1 | NORMAL | UNIQUE |
APPS_TS_SEED
|
 RT_OPER_MATERIAL_ID
|
| AHL_RT_OPER_MATERIALS_N1 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
ASSOCIATION_TYPE_CODE
OBJECT_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| RT_OPER_MATERIAL_ID | NUMBER | Yes | Primary Key, unique identifier for a record in this table | |
| 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 | |
| OBJECT_ID | NUMBER | Yes | Identifier for an operation or a route | |
| INVENTORY_ITEM_ID | NUMBER | Identifier for an item | ||
| INVENTORY_ORG_ID | NUMBER | Identifier for the organization | ||
| REC_TYPE_CODE | VARCHAR2 | (30) | No longer used | |
| ASSOCIATION_TYPE_CODE | VARCHAR2 | (30) | Yes | Attributes which indicates the association type of Material or tool requirement, Whether it is associated with a route or an operation |
| UOM_CODE | VARCHAR2 | (30) | Yes | The unit of measure identifier for a material requirement |
| REVISION_NUMBER | NUMBER | Version number of the material requirement which indicates how many times a material requirement was modified | ||
| QUANTITY | NUMBER | Yes | Quantity of material required | |
| DURATION | NUMBER | Duration of a material needed. | ||
| TIME_SPAN | NUMBER | Total time span of a material needed. | ||
| 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 | |
| ITEM_GROUP_ID | NUMBER | Item Group ID | ||
| POSITION_PATH_ID | NUMBER | Position Path Id | ||
| ITEM_COMP_DETAIL_ID | NUMBER | Item Composition Detail Id | ||
| REWORK_PERCENT | NUMBER | % Rework at Position. | ||
| REPLACE_PERCENT | NUMBER | % Replacement of an item. | ||
| EXCLUDE_FLAG | VARCHAR2 | (1) | Exclude flag | |
| IN_SERVICE | VARCHAR2 | (1) | In Service is to indicate if it's an repairable item. |
Cut, paste (and edit) the following text to query this object:
SELECT RT_OPER_MATERIAL_ID
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_ID
, INVENTORY_ITEM_ID
, INVENTORY_ORG_ID
, REC_TYPE_CODE
, ASSOCIATION_TYPE_CODE
, UOM_CODE
, REVISION_NUMBER
, QUANTITY
, DURATION
, TIME_SPAN
, SECURITY_GROUP_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ITEM_GROUP_ID
, POSITION_PATH_ID
, ITEM_COMP_DETAIL_ID
, REWORK_PERCENT
, REPLACE_PERCENT
, EXCLUDE_FLAG
, IN_SERVICE
FROM AHL.AHL_RT_OPER_MATERIALS;
AHL.AHL_RT_OPER_MATERIALS does not reference any database object
AHL.AHL_RT_OPER_MATERIALS is referenced by following:
APPS
AHL_RT_OPER_MATERIALS
|
|
|
|