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_PRICE_ELEMENT_TYPES

Object Details

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

PON_PRICE_ELEMENT_TYPES stores details of cost factors. Cost factors include costs associated with the movement of goods from one location to another. They also include intangible costs such as the cost of switching over to a new supplier when used in the Sourcing process. This component was called "Price Elements" or "Price Factors" in earlier releases.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PON_PRICE_ELEMENT_TYPES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PRICE_ELEMENT_TYPE_ID ZD_EDITION_NAME
PON_PRICE_ELEMENT_TYPES_U2	FUNCTION-BASED NORMAL	UNIQUE	APPS_TS_TX_IDX	UPPER("PRICE_ELEMENT_CODE")

Columns

Name	Datatype	Length	Mandatory	Comments
PRICE_ELEMENT_TYPE_ID	NUMBER		Yes	Unique system generated ID of the price element
TRADING_PARTNER_ID	NUMBER		Yes	Company trading partner ID
PRICE_ELEMENT_CODE	VARCHAR2	(30)	Yes	Alpha-numeric code for price element defined by user
PRICING_BASIS	VARCHAR2	(30)	Yes	Use lookup code PON_PRICING_BASIS. Values are:PER_UNIT, FIXED_AMOUNT, PERCENTAGE
ENABLED_FLAG	VARCHAR2	(1)	Yes	A flag to indicate whether this price element type is enabled or not: Y / N
SYSTEM_FLAG	VARCHAR2	(1)	Yes	For pre-seeded price element "item price"Y / N
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
ALLOCATION_BASIS	VARCHAR2	(30)		Method for prorating summary charges to the line level (e.g. weight, volume, value)
INVOICE_LINE_TYPE	VARCHAR2	(30)		Invoice line type that will be used in Oracle Accounts Payable corresponding to this cost factor
COST_COMPONENT_CLASS_ID	NUMBER			Identifier of the cost component class. Cost Component Classes are used to identify the individual buckets or component costs that make up the total cost of an item, for example, direct material costs, freight costs, labor costs, production or conversion costs and so on.
COST_ANALYSIS_CODE	VARCHAR2	(4)		Cost Analysis Codes can be used to further break down an individual component cost for more granular tracking or group component costs across multiple component classes for an alternate view of the item cost.
COST_ACQUISITION_CODE	VARCHAR2	(1)		Indicates if the cost factor is of type expense or inventory and records corresponding values as E or I
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT PRICE_ELEMENT_TYPE_ID
,      TRADING_PARTNER_ID
,      PRICE_ELEMENT_CODE
,      PRICING_BASIS
,      ENABLED_FLAG
,      SYSTEM_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      ALLOCATION_BASIS
,      INVOICE_LINE_TYPE
,      COST_COMPONENT_CLASS_ID
,      COST_ANALYSIS_CODE
,      COST_ACQUISITION_CODE
,      ZD_EDITION_NAME
FROM PON.PON_PRICE_ELEMENT_TYPES;

Dependencies

[top of page]

PON.PON_PRICE_ELEMENT_TYPES does not reference any database object

PON.PON_PRICE_ELEMENT_TYPES is referenced by following:

PON: PON_PRICE_ELEMENT_TYPES#