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: PO.PO_PRINT_FORM_FORMATS

Object Details

Object Name:	PO_PRINT_FORM_FORMATS
Object Type:	TABLE
Owner:	PO
FND Design Data:	PO.PO_PRINT_FORM_FORMATS
Subobject Name:
Status:	VALID

Stores Federal Printing Formats, based on Document Type and other details the XML Template is chosen.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PO_PRINT_FORM_FORMATS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FORM_ID
PO_PRINT_FORM_FORMATS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DOCUMENT_TYPE STANDARD_FORM DOCUMENT_FORMAT STYLE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
FORM_ID	NUMBER		Yes	Primary Key
DOCUMENT_TYPE	VARCHAR2	(240)	Yes	Type of Document for which the printing template is being chosen.
STANDARD_FORM	VARCHAR2	(240)	Yes	Standard Form to be used for each Document Type
DOCUMENT_FORMAT	VARCHAR2	(240)	Yes	Document Format for each Standard Form.
INACTIVE_DATE	DATE			Date after which the Printing Format would be Inactive. If null, means Printing Format is active.
FORM_SOURCE	VARCHAR2	(20)		Column to determine the source of the Printing Format.
STYLE_ID	NUMBER			Reference to the Document Style when Source is Purchasing
XMLP_TEMPLATE_CODE	VARCHAR2	(80)		Template Code for Standard Form
DOC_FORMAT_TMPL_CODE	VARCHAR2	(80)		Document Format Template Code
DEFAULT_FLAG	VARCHAR2	(1)		Flag to determine whether the specific Printing Format is default for the Document Type.
CREATION_DATE	DATE			Standard who column - date when this row was created.
CREATED_BY	NUMBER			Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER			Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

Query Text

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


SELECT FORM_ID
,      DOCUMENT_TYPE
,      STANDARD_FORM
,      DOCUMENT_FORMAT
,      INACTIVE_DATE
,      FORM_SOURCE
,      STYLE_ID
,      XMLP_TEMPLATE_CODE
,      DOC_FORMAT_TMPL_CODE
,      DEFAULT_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM PO.PO_PRINT_FORM_FORMATS;

Dependencies

[top of page]

PO.PO_PRINT_FORM_FORMATS does not reference any database object

PO.PO_PRINT_FORM_FORMATS is referenced by following:

PO: PO_PRINT_FORM_FORMATS#