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_DOC_STYLE_HEADERS

Object Details

Object Name:	PO_DOC_STYLE_HEADERS
Object Type:	TABLE
Owner:	PO
Subobject Name:
Status:	VALID

PO_DOC_STYLE_HEADERS contains information about the document style you use in your business.
Document style defines the procurement style across the different stages of the procurement process. It is used to control the display of the document and document usages.
Within Purchasing, users can define a single document style setting for the following type of documents: Standard Purchase Order, Global Agreement and Global Contract.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PO_DOC_STYLE_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	STYLE_ID
PO_DOC_STYLE_HEADERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STYLE_NAME
PO_DOC_STYLE_HEADERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STYLE_DESCRIPTION

Columns

Name	Datatype	Length	Mandatory	Comments
STYLE_ID	NUMBER		Yes	Identifier
STYLE_NAME	VARCHAR2	(240)		The name for the style.
STYLE_DESCRIPTION	VARCHAR2	(240)		The description of the style.
STYLE_TYPE	VARCHAR2	(30)		Type of the Style. The valid values are: DEFAULT/STANDARD
STATUS	VARCHAR2	(30)	Yes	Status of the Style. The valid values are: ACTIVE / INACTIVE from the PO_LOOKUP_CODES table.
ADVANCES_FLAG	VARCHAR2	(1)		Indicate if Advances enabled for this Style.
RETAINAGE_FLAG	VARCHAR2	(1)		Indicate if Retainage enabled for this Style.
PRICE_BREAKS_FLAG	VARCHAR2	(1)		Indicate if Price Breaks enabled for this Style.
PRICE_DIFFERENTIALS_FLAG	VARCHAR2	(1)		Indicate if Price Differentials enabled for this Style.
PROGRESS_PAYMENT_FLAG	VARCHAR2	(1)		Indicate if Progress Payment enabled for this Style.
CONTRACT_FINANCING_FLAG	VARCHAR2	(1)		Indicate if Contract Financing enabled for this Style.
LINE_TYPE_ALLOWED	VARCHAR2	(30)	Yes	Indicate if Line Type is restricted for this Style. The valid values are: ALL / SPECIFIED from the PO_LOOKUP_CODES table.
CREATION_DATE	DATE			Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY	NUMBER	(15)		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.

Query Text

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


SELECT STYLE_ID
,      STYLE_NAME
,      STYLE_DESCRIPTION
,      STYLE_TYPE
,      STATUS
,      ADVANCES_FLAG
,      RETAINAGE_FLAG
,      PRICE_BREAKS_FLAG
,      PRICE_DIFFERENTIALS_FLAG
,      PROGRESS_PAYMENT_FLAG
,      CONTRACT_FINANCING_FLAG
,      LINE_TYPE_ALLOWED
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
FROM PO.PO_DOC_STYLE_HEADERS;

Dependencies

[top of page]

PO.PO_DOC_STYLE_HEADERS does not reference any database object

PO.PO_DOC_STYLE_HEADERS is referenced by following:

APPS: PO_DOC_STYLE_HEADERS