[Home] [Help] [Dependency Information]
Object Name: | PON_FORM_SECTION_FIELDS |
---|---|
Object Type: | TABLE |
Owner: | PON |
FND Design Data: | PON.PON_FORM_SECTION_FIELDS |
Subobject Name: | |
Status: | VALID |
PON_FORM_SECTION_FIELDS stores the relationships between a form, section or abstract and its components (fields and sections). The table captures the order in which the various sections and fields should be displayed in the form, section or abstract.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PON_FORM_SECTION_FIELDS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | FORM_SECTION_FIELD_ID |
PON_FORM_SECTION_FIELDS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
FORM_ID
SECTION_ID |
PON_FORM_SECTION_FIELD_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
FORM_ID
FIELD_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORM_SECTION_FIELD_ID | NUMBER | Yes | Unique generated ID. | |
FORM_ID | NUMBER | Yes | Unique Id of the Form for which the field/ section is added. | |
TYPE | VARCHAR2 | (30) | Yes | Indicates if the row is a field or a section inside the form/section. Values can be FIELD - field directly inside the form; SECTION -a section. |
FIELD_CODE | VARCHAR2 | (25) | Code of the field. | |
SEQUENCE_NUMBER | NUMBER | Yes | Order in which the field/ section will appear. | |
REQUIRED | VARCHAR2 | (1) | Indicates whether the current field is a mandatory field or not. | |
SECTION_ID | NUMBER | If the type is not FIELD, this column will populated with the section id for the current section inside the form | ||
DISPLAY_ON_MAIN_PAGE | VARCHAR2 | (1) | This is valid only for abstract. Determines if the column is displayed on the main page. | |
ENABLED | VARCHAR2 | (1) | This is valid only for abstract. Determines if the column is enabled for the abstract. | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT FORM_SECTION_FIELD_ID
, FORM_ID
, TYPE
, FIELD_CODE
, SEQUENCE_NUMBER
, REQUIRED
, SECTION_ID
, DISPLAY_ON_MAIN_PAGE
, ENABLED
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM PON.PON_FORM_SECTION_FIELDS;
PON.PON_FORM_SECTION_FIELDS does not reference any database object
PON.PON_FORM_SECTION_FIELDS is referenced by following:
|
|
|