eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: PON.PON_FORM_SECTION_COMPILED

Object Details

Object Name:	PON_FORM_SECTION_COMPILED
Object Type:	TABLE
Owner:	PON
FND Design Data:	PON.PON_FORM_SECTION_COMPILED
Subobject Name:
Status:	VALID

PON_FORM_SECTION_COMPILED will store the "compiled form" of PON_FORM_SECTION_FIELDS. The "compiled form" will have a record for every section and fields inside the non repeatable sections present in the form. Additionally a repeatable section present inside a non-repeatable section of a form or inside another repeatable section will have 1 record corresponding to the form or repeatable section respectively in this table. It also contains the location name of the field in PON_FORM_FIELD_VALUES that will store the value of the form/ section field.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PON_FORM_SECTION_COMPILED_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FORM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
FORM_SECTION_FIELD_ID	NUMBER			Foreign Key to PON_FORM_SECTION_FIELDS.
FORM_ID	NUMBER		Yes	Foreign Key to PON_FORM_SECTION_FIELDS.
TYPE	VARCHAR2	(30)	Yes	Indicates the type of the compiled row. Possible values are FORM, FORM_FIELD, INNER_NORMAL_SECTION, INNER_REPEAT_SECTION, INNER_SECTION_FIELD, INNER_SECTION_REPEAT_SECTION, NORMAL_SECTION, REPEAT_SECTION, SECTION_FIELD
FIELD_CODE	VARCHAR2	(25)		Foreign Key to PON_FIELDS table in case this row corresponds to a field.
INTERNAL_SEQUENCE_NUMBER	NUMBER		Yes	Actual displayed order of all fields and sections.
MAPPING_FIELD_VALUE_COLUMN	VARCHAR2	(30)		Column to which it maps to in the values table. E.g. TEXTCOL20 or DATECOL11 etc.
REQUIRED	VARCHAR2	(1)		Indicates whether the current field is a mandatory field or not.
DISPLAY_ON_MAIN_PAGE	VARCHAR2	(1)		This is valid only for abstract. Determines if the field is available on the main page.
ENABLED	VARCHAR2	(1)		This is valid only for abstract. Determines if the field/section 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
LEVEL2_SECTION_ID	NUMBER			Level 2 section id
LEVEL1_SECTION_ID	NUMBER			Level 1 section id
REPEATING_SECTION_ID	NUMBER			Repeating section id

Query Text

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


SELECT FORM_SECTION_FIELD_ID
,      FORM_ID
,      TYPE
,      FIELD_CODE
,      INTERNAL_SEQUENCE_NUMBER
,      MAPPING_FIELD_VALUE_COLUMN
,      REQUIRED
,      DISPLAY_ON_MAIN_PAGE
,      ENABLED
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LEVEL2_SECTION_ID
,      LEVEL1_SECTION_ID
,      REPEATING_SECTION_ID
FROM PON.PON_FORM_SECTION_COMPILED;

Dependencies

[top of page]

PON.PON_FORM_SECTION_COMPILED does not reference any database object

PON.PON_FORM_SECTION_COMPILED is referenced by following:

APPS: PON_FORM_SECTION_COMPILED