[Home] [Help] [Dependency Information]
Object Name: | CSC_PLAN_HEADERS_TL |
---|---|
Object Type: | TABLE |
Owner: | CSC |
FND Design Data: | CSC.CSC_PLAN_HEADERS_TL |
Subobject Name: | |
Status: | VALID |
CSC_PLAN_HEADERS_TL table stores information about the translatable columns in CSC_PLAN_HEADERS_B table, ie the plan name and description. It also stores the source language which is the Oracle session language used at the time of plan creation, and the equivalent name and description of the plan for all the languages defined in FND_LANGUAGES.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CSC_PLAN_HEADERS_TL_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
PLAN_ID
LANGUAGE |
CSC_PLAN_HEADERS_TL_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
NAME
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | (15) | Yes | References PLAN_ID of CSC_RS_PLANS_B |
NAME | VARCHAR2 | (90) | Yes | Unique name of the plan template |
DESCRIPTION | VARCHAR2 | (720) | Description of the plan | |
LANGUAGE | VARCHAR2 | (12) | Yes | Language code of the text in name and description |
SOURCE_LANG | VARCHAR2 | (12) | Yes | Language code of the record from which this was copied during the upgrade |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
SEEDED_FLAG | VARCHAR2 | (3) | 'Y' denotes the record is seeded when packaged;'N' denotes a customer created record. | |
APPLICATION_ID | NUMBER | The ID of the application that owns this record when seeding data in this table. |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, NAME
, DESCRIPTION
, LANGUAGE
, SOURCE_LANG
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, SEEDED_FLAG
, APPLICATION_ID
FROM CSC.CSC_PLAN_HEADERS_TL;
CSC.CSC_PLAN_HEADERS_TL does not reference any database object
CSC.CSC_PLAN_HEADERS_TL is referenced by following:
|
|
|