[Home] [Help] [Dependency Information]
Object Name: | PON_FIELDS |
---|---|
Object Type: | TABLE |
Owner: | PON |
FND Design Data: | PON.PON_FIELDS |
Subobject Name: | |
Status: | VALID |
PON_FIELDS stores the information about a field. Fields along with sections are a part of the building blocks for forms, sections and abstract.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PON_FIELDS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | FIELD_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FIELD_CODE | VARCHAR2 | (25) | Yes | Unique code of the field. |
DATATYPE | VARCHAR2 | (20) | Yes | The stores the value for the type of field. Possible values are DATETIME, NUMBER, DATE, TEXT or AMOUNT |
SYSTEM_FLAG | VARCHAR2 | (1) | Yes | Indicates if a field is seeded. The value Y indicates that the field is seeded. |
STATUS | VARCHAR2 | (20) | Yes | Indicates the status of the field. Possible values are DRAFT-Draft; ACTIVE-Active; INACTIVE-Inactive |
VALUE_SET_NAME | VARCHAR2 | (60) | Name of the value-set to be used (This column will be applicable if the data-type is Text) | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Yes | Standard Who column | |
SYSTEM_FIELD_LOV_FLAG | VARCHAR2 | (1) | System field lov flag | |
VALUE_SET_QUERY | VARCHAR2 | (4000) | If the value-set validation list type is 'table' then this will store the value-set query along with the field. | |
VALUE_SET_ORDER_BY | VARCHAR2 | (250) | If the value-set validation list type is 'table' then we will store the order by statement of value-set query. | |
VALUE_SET_ID_EXISTS | VARCHAR2 | (1) | Indicates if the id column exists for the value set. |
Cut, paste (and edit) the following text to query this object:
SELECT FIELD_CODE
, DATATYPE
, SYSTEM_FLAG
, STATUS
, VALUE_SET_NAME
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, SYSTEM_FIELD_LOV_FLAG
, VALUE_SET_QUERY
, VALUE_SET_ORDER_BY
, VALUE_SET_ID_EXISTS
FROM PON.PON_FIELDS;
PON.PON_FIELDS does not reference any database object
PON.PON_FIELDS is referenced by following:
|
|
|