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
FND Design Data:	PO.PO_DOC_STYLE_HEADERS
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 ZD_EDITION_NAME
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.
DELIVERABLE_HOLD_FLAG	VARCHAR2	(1)		Flag to indicate whether to place the PO invoice on hold if there is a overdue contract deliverable
ENHANCED_PRICING_FLAG	VARCHAR2	(1)		Flag to indicate whether Oracle advanced pricing is enabled for the POs of this style
CHANGE_PROCESS_TYPE	VARCHAR2	(30)		Indicates the change order process. Valid values are MODIFICATION, CHANGE_ORDER
CLM_FLAG	VARCHAR2	(1)		Indicates where the style is enabled for Contract Lifecycle Management
CTRL_ACTN_IN_CHGDOC_FLAG	VARCHAR2	(1)		Indicates whether control actions like Cancel, hold etc are allowed on a Modification document
INFO_FUNDED_SLIN_FLAG	VARCHAR2	(1)		For future use
SINGLE_DISTRIBUTION_FLAG	VARCHAR2	(1)		For Future Use
COMPLEX_PRICING_FLAG	VARCHAR2	(1)		For Future use
WF_APPROVAL_ITEMTYPE	VARCHAR2	(8)		Item type of the Approval workflow process. Applicable for CLM style
WF_APPROVAL_PROCESS	VARCHAR2	(30)		Top process for the approval workflow. Applicable for CLM style
AME_TRANSACTION_TYPE	VARCHAR2	(50)		AME Transaction Type for PO Approval. Applicable for CLM style
MOD_AME_TRANSACTION_TYPE	VARCHAR2	(50)		AME Transaction type for Modification Approval. Applicable for CLM style
WARRANT_ENABLED_FLAG	VARCHAR2	(1)		Warrant Enabled Flag
WARRANT_TYPE	VARCHAR2	(30)		Warrant type associated with the document style
CONC_MODS_ENABLED_FLAG	VARCHAR2	(1)
ZD_EDITION_NAME	VARCHAR2	(30)	Yes
WITHDRAW_ALLOWED_FLAG	VARCHAR2	(1)		Whether Withdraw Document Feature is allowed or not.
SEND_WITHDRW_NOTF_FLAG	VARCHAR2	(1)		Withdraw Notifications should be sent or not.
PAR_AME_TRANSACTION_TYPE	VARCHAR2	(50)
PAR_AUTO_ASSIGN_FLAG	VARCHAR2	(1)
PAR_AUTO_ASSIGN_ROLE	VARCHAR2	(30)
PAR_DOC_FORMAT_TMPL_CODE	VARCHAR2	(80)
PAR_ENABLED_FLAG	VARCHAR2	(1)

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
,      DELIVERABLE_HOLD_FLAG
,      ENHANCED_PRICING_FLAG
,      CHANGE_PROCESS_TYPE
,      CLM_FLAG
,      CTRL_ACTN_IN_CHGDOC_FLAG
,      INFO_FUNDED_SLIN_FLAG
,      SINGLE_DISTRIBUTION_FLAG
,      COMPLEX_PRICING_FLAG
,      WF_APPROVAL_ITEMTYPE
,      WF_APPROVAL_PROCESS
,      AME_TRANSACTION_TYPE
,      MOD_AME_TRANSACTION_TYPE
,      WARRANT_ENABLED_FLAG
,      WARRANT_TYPE
,      CONC_MODS_ENABLED_FLAG
,      ZD_EDITION_NAME
,      WITHDRAW_ALLOWED_FLAG
,      SEND_WITHDRW_NOTF_FLAG
,      PAR_AME_TRANSACTION_TYPE
,      PAR_AUTO_ASSIGN_FLAG
,      PAR_AUTO_ASSIGN_ROLE
,      PAR_DOC_FORMAT_TMPL_CODE
,      PAR_ENABLED_FLAG
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:

PO: PO_DOC_STYLE_HEADERS#