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: ViewPON.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:

SchemaAPPS
SynonymPON_PRICE_ELEMENT_TYPES
SynonymPON_PRICE_ELEMENT_TYPES_TL
APPS.PON_PRICE_ELEMENT_TYPES_VL is referenced by following:

SchemaAPPS
Package BodyAP_IMPORT_VALIDATION_PKG - show dependent code
ViewAP_INVOICE_LINES_V
Package BodyINL_CHARGE_PVT - show dependent code
ViewINL_DET_LANDED_COSTS_V
Package BodyPON_CF_TYPE_GRP - show dependent code
PL/SQL PackagePON_CF_TYPE_GRP - show dependent code
Package BodyPON_CLM_CLO_UTIL_PKG - show dependent code
Package BodyPON_NEGOTIATION_COPY_GRP - show dependent code
Package BodyPON_PRINTING_PKG - show dependent code
Package BodyPO_CHARGES_GRP - show dependent code
Package BodyRCV_CHARGES_GRP - show dependent code