[Home] [Help] [Dependency Information]
Object Name: | JTF_DSP_SECTION_ITEMS |
---|---|
Object Type: | TABLE |
Owner: | JTF |
FND Design Data: | JTF.JTF_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_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JTF_DSP_SECTION_ITEMS_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE | SECTION_ITEM_ID |
JTF_DSP_SECTION_ITEMS_U2 | NORMAL | UNIQUE | APPS_TS_ARCHIVE |
SECTION_ID
INVENTORY_ITEM_ID ORGANIZATION_ID |
JTF_DSP_SECTION_ITEMS_N1 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | INVENTORY_ITEM_ID |
JTF_DSP_SECTION_ITEMS_N2 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | SECTION_ID |
JTF_DSP_SECTION_ITEMS_N3 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE |
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 - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
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. | |
SECURITY_GROUP_ID | NUMBER | Security Group Identifier. |
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
, SECTION_ID
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, SORT_ORDER
, ASSOCIATION_REASON_CODE
, SECURITY_GROUP_ID
FROM JTF.JTF_DSP_SECTION_ITEMS;
JTF.JTF_DSP_SECTION_ITEMS does not reference any database object
JTF.JTF_DSP_SECTION_ITEMS is referenced by following:
|
|
|