[Home] [Help] [Dependency Information]
Object Name: | IBE_DSP_SECTION_ITEMS |
---|---|
Object Type: | TABLE |
Owner: | IBE |
FND Design Data: | IBE.IBE_DSP_SECTION_ITEMS |
Subobject Name: | |
Status: | VALID |
This table contains relationship between sections and items in the catalog. Each section can have one or more items, and also each item can belong to one or more sections.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBE_DSP_SECTION_ITEMS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | SECTION_ITEM_ID |
IBE_DSP_SECTION_ITEMS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SECTION_ID
INVENTORY_ITEM_ID ORGANIZATION_ID |
IBE_DSP_SECTION_ITEMS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | INVENTORY_ITEM_ID |
IBE_DSP_SECTION_ITEMS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SECTION_ID
SORT_ORDER INVENTORY_ITEM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SECTION_ITEM_ID | NUMBER | Yes | Section item identifier | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Object Version Number for Locking. |
CREATED_BY | NUMBER | Yes | Standard who column | |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column | ||
SECURITY_GROUP_ID | NUMBER | Security Group Identifier. | ||
SECTION_ID | NUMBER | Yes | Section identifier | |
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item identifier | |
ORGANIZATION_ID | NUMBER | Yes | Inventory organization identifier for the item | |
START_DATE_ACTIVE | DATE | Yes | Start date active | |
END_DATE_ACTIVE | DATE | End date active | ||
SORT_ORDER | NUMBER | The order in which the items will be displayed under a section. | ||
ASSOCIATION_REASON_CODE | VARCHAR2 | (240) | Reason why/how this item was related to the section. For e.g., it could be due to auto-placement rule or it could be a manual association. | |
USAGE_NAME | VARCHAR2 | (255) | Name of usage defined in CZ_MODEL_USAGES and linked to this item |
Cut, paste (and edit) the following text to query this object:
SELECT SECTION_ITEM_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, SECTION_ID
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, SORT_ORDER
, ASSOCIATION_REASON_CODE
, USAGE_NAME
FROM IBE.IBE_DSP_SECTION_ITEMS;
IBE.IBE_DSP_SECTION_ITEMS does not reference any database object
IBE.IBE_DSP_SECTION_ITEMS is referenced by following:
|
|
|