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_FORMS_SECTIONS

Object Details

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

PON_FORMS_SECTIONS stores the header details for a form, section or abstract. A form/section can be uniquely identified by the FORM_ID or by the combination of FORM_CODE and FORM_VERSION.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PON_FORMS_SECTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FORM_ID ZD_EDITION_NAME
PON_FORMS_SECTIONS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	FORM_CODE FORM_VERSION ZD_EDITION_NAME
SYS_IL0000409609C00020$$	LOB	UNIQUE	APPS_TS_TX_DATA

Columns

Name	Datatype	Length	Mandatory	Comments
FORM_ID	NUMBER		Yes	Unique Id of the Form
FORM_CODE	VARCHAR2	(20)	Yes	Unique Code for the form. For abstract this will always be ABSTRACT.
FORM_VERSION	NUMBER		Yes	Version of the form.
TYPE	VARCHAR2	(30)	Yes	This column indicates if the record is for a form, section or abstract. Possible values are FORM- Form; SECTION - Section; ABSTRACT- Abstract
STATUS	VARCHAR2	(20)	Yes	Indicates the status. Possible values are DRAFT-Draft; ACTIVE-Active; INACTIVE-Inactive
FORM_USAGE	VARCHAR2	(30)		Indicates if the form/ abstract is created for an event or negotiation. Possible values are EVENT- Event; NEGOTIATION - Negotiation
CUSTOMIZED_FLAG	VARCHAR2	(1)		Flag to indicate if the record has been customized or not.( This column will be applicable for ententies shipped with the application).
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
IS_REPEATING_SECTION_FLAG	VARCHAR2	(1)		This column is applicable to sections only. Indicates if the section is a repeating section or not.
JRAD_XML_REGION_NAME	VARCHAR2	(100)		This column will be applicable to forms and repeating sections only. This stores the name of the xml region for entering the data for the form/ repeating section.
XDO_DATA_SOURCE_CODE	VARCHAR2	(80)		Data source code for this form as generated in the Xml Publisher application.
XDO_STYLESHEET_CODE	VARCHAR2	(80)		Stylesheet associated with the form.
HAS_SYSTEM_FIELDS_FLAG	VARCHAR2	(1)		Indicates if the form/ section has system fields.
SYSTEM_FLAG	VARCHAR2	(1)		Indicates if the form/section was shipped with the application.
JRAD_XML_REGION_NAME_DISP	VARCHAR2	(100)		This column will be applicable to forms and repeating sections only. This stores the name of the xml region for displaying the data for the form/ repeating section.
XML_QUERY	CLOB	(4000)		This stores the query to retrieve the data of the form for xml generation.
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT FORM_ID
,      FORM_CODE
,      FORM_VERSION
,      TYPE
,      STATUS
,      FORM_USAGE
,      CUSTOMIZED_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      IS_REPEATING_SECTION_FLAG
,      JRAD_XML_REGION_NAME
,      XDO_DATA_SOURCE_CODE
,      XDO_STYLESHEET_CODE
,      HAS_SYSTEM_FIELDS_FLAG
,      SYSTEM_FLAG
,      JRAD_XML_REGION_NAME_DISP
,      XML_QUERY
,      ZD_EDITION_NAME
FROM PON.PON_FORMS_SECTIONS;

Dependencies

[top of page]

PON.PON_FORMS_SECTIONS does not reference any database object

PON.PON_FORMS_SECTIONS is referenced by following:

PON: PON_FORMS_SECTIONS#