[Home] [Help] [Dependency Information]
Object Name: | AHL_PRODTYPE_ZONES |
---|---|
Object Type: | TABLE |
Owner: | AHL |
FND Design Data: | AHL.AHL_PRODTYPE_ZONES |
Subobject Name: | |
Status: | VALID |
This table stores the association between product type, zone and sub zone. This is an intersection table required due to the many to many relationship between the entities product type, zone and sub zone. A product type, zone and sub zone can be referenced in a Route and in an Operation.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AHL_PRODTYPE_ZONES_U1 | NORMAL | UNIQUE | APPS_TS_SEED | PRODTYPE_ZONE_ID |
AHL_PRODTYPE_ZONES_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
PRODUCT_TYPE_CODE
ZONE_CODE SUB_ZONE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRODTYPE_ZONE_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 | |
PRODUCT_TYPE_CODE | VARCHAR2 | (30) | Yes | Unique identifier for product type |
ZONE_CODE | VARCHAR2 | (30) | Yes | Unique identifier for Zone |
ACTIVE_START_DATE | DATE | Obsolete -This record indicates the date from which the record will be activated | ||
ACTIVE_END_DATE | DATE | Obsolete -This record indicates the date from which the record will be deactivated | ||
SUB_ZONE_CODE | VARCHAR2 | (30) | Unique identifier for Sub Zone | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT PRODTYPE_ZONE_ID
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, PRODUCT_TYPE_CODE
, ZONE_CODE
, ACTIVE_START_DATE
, ACTIVE_END_DATE
, SUB_ZONE_CODE
, SECURITY_GROUP_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM AHL.AHL_PRODTYPE_ZONES;
AHL.AHL_PRODTYPE_ZONES does not reference any database object
AHL.AHL_PRODTYPE_ZONES is referenced by following:
|
|
|