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_PRICE_ADJ_ATTRIBS_ARCHIVE

Object Details

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

Price Adjustment Attribute Details for PO Line Price Adjustments - History

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PO_PRICE_ADJ_ATTRIBS_ARCH_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PRICE_ADJ_ATTRIB_ID REVISION_NUM
PO_PRICE_ADJ_ATTRIBS_ARCH_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRICE_ADJUSTMENT_ID
PO_PRICE_ADJ_ATTRIBS_ARCH_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRICING_CONTEXT PRICING_ATTRIBUTE PRICING_ATTR_VALUE_FROM

Columns

Name	Datatype	Length	Mandatory	Comments
PRICE_ADJUSTMENT_ID	NUMBER		Yes	Price Adjustment Unique Identifier
PRICING_CONTEXT	VARCHAR2	(30)	Yes	Context for product or pricing attribute
PRICING_ATTRIBUTE	VARCHAR2	(30)	Yes	Product or pricing attribute
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	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).
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER			Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
REQUEST_ID	NUMBER			Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PRICING_ATTR_VALUE_FROM	VARCHAR2	(240)		From Value from price list or modifier setup
PRICING_ATTR_VALUE_TO	VARCHAR2	(240)		Return value for qualifier attribute
COMPARISON_OPERATOR	VARCHAR2	(30)		Operator code of the qualifier
FLEX_TITLE	VARCHAR2	(60)	Yes	Title based on type of the attribute
PRICE_ADJ_ATTRIB_ID	NUMBER		Yes	Unique identifier for Price Adjustment Attribute
LATEST_EXTERNAL_FLAG	VARCHAR2	(1)		Indicates whether this is the latest archived revision
REVISION_NUM	NUMBER		Yes	Revision number of the record

Query Text

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


SELECT PRICE_ADJUSTMENT_ID
,      PRICING_CONTEXT
,      PRICING_ATTRIBUTE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      PRICING_ATTR_VALUE_FROM
,      PRICING_ATTR_VALUE_TO
,      COMPARISON_OPERATOR
,      FLEX_TITLE
,      PRICE_ADJ_ATTRIB_ID
,      LATEST_EXTERNAL_FLAG
,      REVISION_NUM
FROM PO.PO_PRICE_ADJ_ATTRIBS_ARCHIVE;

Dependencies

[top of page]

PO.PO_PRICE_ADJ_ATTRIBS_ARCHIVE does not reference any database object

PO.PO_PRICE_ADJ_ATTRIBS_ARCHIVE is referenced by following:

PO: PO_PRICE_ADJ_ATTRIBS_ARCHIVE#