[Home] [Help] [Dependency Information]
Object Name: | OKS_SERV_AVAIL_EXCEPTS |
---|---|
Object Type: | TABLE |
Owner: | OKS |
FND Design Data: | OKS.OKS_SERV_AVAIL_EXCEPTS |
Subobject Name: | |
Status: | VALID |
This table stores exception information for service availabilities and populated through the detail part of service availability UI where users can enter party or product to specify service is not available for them and generally available for others. This table is closely related to the table OKS_SERV_AVAILS where generally available services are stored. These two tables are combined together to get the information of available services for service programs, warranties, and extended warranties. Service Availability inclusion and exclusion rules are honored while selling services in upstream applications like quoting, Order Management The Generally Available check box determines whether the entries in Product and Party tabs are inclusions or exclusions. By selecting the Generally Available check box for a service, all products and parties listed will be excluded from receiving that service. By leaving the Generally Available check box unselected, the products and parties listed will be the only ones eligible to receive that service.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKS_SERV_AVAIL_EXCEPTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
OKS_SERV_AVAIL_EXCEPTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | OBJECT1_ID1 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Internal Unique Identifier. | |
SAV_ID | NUMBER | Yes | Foreign key references to the Id in oks_serv_avils table. | |
OBJECT1_ID1 | VARCHAR2 | (40) | Party or Customer ID | |
OBJECT1_ID2 | VARCHAR2 | (200) | Not used | |
JTOT_OBJECT1_CODE | VARCHAR2 | (30) | Yes | Foreign key to JTF_OBJECTS_B. JTF Object code identifying the OKX view for party or product. Identifies the Source Object (Table/View/Object) that contains the. |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed. |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
MANUFACTURING_ORG_ID | NUMBER | (15) | Yes | Unique item organization identifier. |
REVISION_LOW | VARCHAR2 | (45) | Item Revision (low). | |
REVISION_HIGH | VARCHAR2 | (45) | Item Revision (high). | |
START_DATE_ACTIVE | DATE | Service availability exception effective start date. | ||
END_DATE_ACTIVE | DATE | Service availability exception effective end date. | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Typically, a reference field from which a descriptive flexfield can get a context field value (optional, but recommended). | |
ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield | |
ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield | |
ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield | |
ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield | |
ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield | |
ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield | |
ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield | |
ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield | |
ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield | |
ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield | |
ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield | |
ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield | |
ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield | |
ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield | |
ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield | |
SECURITY_GROUP_ID | NUMBER | Used to create a Virtual Private Database which was originally designed to be used by Hosting services. Now obsolete. |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, SAV_ID
, OBJECT1_ID1
, OBJECT1_ID2
, JTOT_OBJECT1_CODE
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, MANUFACTURING_ORG_ID
, REVISION_LOW
, REVISION_HIGH
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
FROM OKS.OKS_SERV_AVAIL_EXCEPTS;
OKS.OKS_SERV_AVAIL_EXCEPTS does not reference any database object
OKS.OKS_SERV_AVAIL_EXCEPTS is referenced by following:
|
|
|