[Home] [Help] [Dependency Information]
Object Name: | GR_WORK_COUNTRY |
---|---|
Object Type: | TABLE |
Owner: | GR |
FND Design Data: | GR.GR_WORK_COUNTRY |
Subobject Name: | |
Status: | VALID |
Contains a temporary table used during the heavy element build process.
Tablespace: | APPS_TS_NOLOGGING |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GR_WORK_COUNTRY_PK | NORMAL | UNIQUE | APPS_TS_NOLOGGING |
ITEM_CODE
SESSION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SESSION_ID | NUMBER | Yes | Surrogate key | |
ITEM_CODE | VARCHAR2 | (32) | Yes | The item code |
ALPHA_VALUE | VARCHAR2 | (240) | Yes | The alpha value |
PROPERTY_ID | VARCHAR2 | (6) | Yes | The property id |
LABEL_CODE | VARCHAR2 | (5) | Yes | Label code |
SEQ_NUMBER | NUMBER | (8) | Yes | Display order |
INGREDIENT_ITEM_CODE | VARCHAR2 | (32) | Yes | Ingredient item code |
Cut, paste (and edit) the following text to query this object:
SELECT SESSION_ID
, ITEM_CODE
, ALPHA_VALUE
, PROPERTY_ID
, LABEL_CODE
, SEQ_NUMBER
, INGREDIENT_ITEM_CODE
FROM GR.GR_WORK_COUNTRY;
GR.GR_WORK_COUNTRY does not reference any database object
GR.GR_WORK_COUNTRY is referenced by following:
|
|
|