[Home] [Help] [Dependency Information]
Object Name: | PSB_SERVICE_PACKAGES |
---|---|
Object Type: | TABLE |
Owner: | PSB |
FND Design Data: | PSB.PSB_SERVICE_PACKAGES |
Subobject Name: | |
Status: | VALID |
PSB_SERVICE_PACKAGES stores the definition information of service
packages. Service packages are always created for a global worksheet.
When a new worksheet is created, it automatically creates one BASE
service package, and all items are assigned to this service package.
Budget users can create further service packages and assign worksheet
line items to these service packages.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PSB_SERVICE_PACKAGES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | SERVICE_PACKAGE_ID |
PSB_SERVICE_PACKAGES_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
GLOBAL_WORKSHEET_ID
SERVICE_PACKAGE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SERVICE_PACKAGE_ID | NUMBER | (20) | Yes | Service package unique identifier |
GLOBAL_WORKSHEET_ID | NUMBER | (15) | Yes | Worksheet unique identifier for the global worksheet for which this service package is created |
BASE_SERVICE_PACKAGE | VARCHAR2 | (1) | Indicates if this is the base service package for which the global worksheet was created | |
NAME | VARCHAR2 | (30) | Yes | Name of the service package |
SHORT_NAME | VARCHAR2 | (15) | Yes | Service package short name used as the identifier |
DESCRIPTION | VARCHAR2 | (2000) | Service package description | |
PRIORITY | NUMBER | Priority assigned to service package | ||
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield Context |
Cut, paste (and edit) the following text to query this object:
SELECT SERVICE_PACKAGE_ID
, GLOBAL_WORKSHEET_ID
, BASE_SERVICE_PACKAGE
, NAME
, SHORT_NAME
, DESCRIPTION
, PRIORITY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, CONTEXT
FROM PSB.PSB_SERVICE_PACKAGES;
PSB.PSB_SERVICE_PACKAGES does not reference any database object
PSB.PSB_SERVICE_PACKAGES is referenced by following:
|
|
|