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]

VIEW: APPS.PON_PRICE_ELEMENT_TYPES_VL

Object Details

Object Name:	PON_PRICE_ELEMENT_TYPES_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PON.PON_PRICE_ELEMENT_TYPES_VL
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

View to access price element type name and description in the session language.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Identfier
PRICE_ELEMENT_TYPE_ID	NUMBER		Yes	Unique system generated ID of the price element
NAME	VARCHAR2	(80)	Yes	Name of price element
DESCRIPTION	VARCHAR2	(240)	Yes	Description of 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_BASISValues 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

Query Text

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


SELECT ROW_ID
,      PRICE_ELEMENT_TYPE_ID
,      NAME
,      DESCRIPTION
,      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
FROM APPS.PON_PRICE_ELEMENT_TYPES_VL;

Dependencies

[top of page]

APPS.PON_PRICE_ELEMENT_TYPES_VL references the following:

APPS: PON_PRICE_ELEMENT_TYPES; PON_PRICE_ELEMENT_TYPES_TL

APPS.PON_PRICE_ELEMENT_TYPES_VL is referenced by following:

APPS: AP_IMPORT_VALIDATION_PKG - show dependent code; AP_INVOICE_LINES_V; INL_CHARGE_PVT - show dependent code; PON_CF_TYPE_GRP - show dependent code; PON_CF_TYPE_GRP - show dependent code; PON_NEGOTIATION_COPY_GRP - show dependent code; PON_PRINTING_PKG - show dependent code; PO_CHARGES_GRP - show dependent code; RCV_CHARGES_GRP - show dependent code