Skip to content

DBA Data[Home] [Help] [Dependency Information]

TABLE: IEB.IEB_SERVICE_PLANS

Object Details
Object Name: IEB_SERVICE_PLANS
Object Type: TABLE
Owner: IEB
FND Design Data: TableIEB.IEB_SERVICE_PLANS
Subobject Name:
Status: VALID


Summary information of service plans.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IEB_SERVICE_PLANS_PK_U NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSVCPLN_ID
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
SVCPLN_ID NUMBER (15) Yes Service Plan ID
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
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
SERVICE_PLAN_NAME VARCHAR2 (80) Yes Service Plan Name
DIRECTION VARCHAR2 (32) Yes Inbound or outbound
TREATMENT VARCHAR2 (80)
Name of handling mechnism - reserved for future use
DESCRIPTION VARCHAR2 (240)
Optional description
OBJECT_VERSION_NUMBER NUMBER

Sequential number used for database locking control when usinging HTML as a user interface.
SECURITY_GROUP_ID NUMBER (15)
This column is the subscriber?s unique ID that enables secure and exclusive data access for Application Hosting Support.
MEDIA_TYPE_ID NUMBER (15)
Media Type ID
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SVCPLN_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SERVICE_PLAN_NAME
,      DIRECTION
,      TREATMENT
,      DESCRIPTION
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      MEDIA_TYPE_ID
,      ZD_EDITION_NAME
FROM IEB.IEB_SERVICE_PLANS;

Dependencies

[top of page]

IEB.IEB_SERVICE_PLANS does not reference any database object

IEB.IEB_SERVICE_PLANS is referenced by following:

SchemaIEB
ViewIEB_SERVICE_PLANS#