[Home] [Help] [Dependency Information]
Object Name: | AMS_ITEM_ATTRIBUTES |
---|---|
Object Type: | TABLE |
Owner: | AMS |
FND Design Data: | AMS.AMS_ITEM_ATTRIBUTES |
Subobject Name: | |
Status: | VALID |
This table will store Oracle Inventory Information and OMO information. This table is created as certain attributes such as owner and effective dates cannot be captured in inventory tables and OMO would use these columns for workflow.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMS_ITEM_ATTRIBUTES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ITEM_OWNER_ID |
AMS_ITEM_ATTRIBUTES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
INVENTORY_ITEM_ID
ORGANIZATION_ID |
AMS_ITEM_ATTRIBUTES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | OWNER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_OWNER_ID | NUMBER | Yes | Unique Identifier | |
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) | Yes | Standard WHO Column |
OBJECT_VERSION_NUMBER | NUMBER | Yes | This column is used for locking purpose. | |
INVENTORY_ITEM_ID | NUMBER | Yes | This key is FK to mtl_system_items table. It stores the item unique identifier. | |
ORGANIZATION_ID | NUMBER | Yes | Organization to which the item belongs | |
ITEM_NUMBER | VARCHAR2 | (240) | Yes | This col is the ITEM NUMBER of a product. |
OWNER_ID | NUMBER | Yes | Owner of the product. | |
STATUS_CODE | VARCHAR2 | (240) | Yes | status of the product |
EFFECTIVE_DATE | DATE | Yes | Effectivity date of the product. | |
IS_MASTER_ITEM | VARCHAR2 | (1) | Yes | This column will identify whether the item being created is Master or other organization item. |
ITEM_SETUP_TYPE | VARCHAR2 | (1) | Yes | This column will identify whether the item being created is Standard or Bundled. |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
CUSTOM_SETUP_ID | NUMBER | Denotes the custom setup used to create this item. |
Cut, paste (and edit) the following text to query this object:
SELECT ITEM_OWNER_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, ITEM_NUMBER
, OWNER_ID
, STATUS_CODE
, EFFECTIVE_DATE
, IS_MASTER_ITEM
, ITEM_SETUP_TYPE
, SECURITY_GROUP_ID
, CUSTOM_SETUP_ID
FROM AMS.AMS_ITEM_ATTRIBUTES;
AMS.AMS_ITEM_ATTRIBUTES does not reference any database object
AMS.AMS_ITEM_ATTRIBUTES is referenced by following:
|
|
|