DBA Data[Home] [Help] [Dependency Information]

TABLE: PON.PON_PRICE_ELEMENT_TYPES_TL

Object Details
Object Name: PON_PRICE_ELEMENT_TYPES_TL
Object Type: TABLE
Owner: PON
FND Design Data: TablePON.PON_PRICE_ELEMENT_TYPES_TL
Subobject Name:
Status: VALID


PON_PRICE_ELEMENT_TYPES_TL stores details of price element type languages. Each row includes specific information about each price element language such as language, source language, price element type ID, trading partner ID, name, description etc.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PON_PRICE_ELEMENT_TYPES_TL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRICE_ELEMENT_TYPE_ID
ColumnLANGUAGE
PON_PRICE_ELEMENT_TYPES_TL_U2 FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnUPPER("NAME")
Columns
Name Datatype Length Mandatory Comments
PRICE_ELEMENT_TYPE_ID NUMBER
Yes Unique Price Element Identifier
TRADING_PARTNER_ID NUMBER
Yes company trading partner id
NAME VARCHAR2 (80) Yes Name of price element
DESCRIPTION VARCHAR2 (240) Yes Description of price element
LANGUAGE VARCHAR2 (4) Yes Language of price element
SOURCE_LANG VARCHAR2 (4) Yes Language of price element in which it was first created
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
Query Text

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


SELECT PRICE_ELEMENT_TYPE_ID
,      TRADING_PARTNER_ID
,      NAME
,      DESCRIPTION
,      LANGUAGE
,      SOURCE_LANG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM PON.PON_PRICE_ELEMENT_TYPES_TL;

Dependencies

[top of page]

PON.PON_PRICE_ELEMENT_TYPES_TL does not reference any database object

PON.PON_PRICE_ELEMENT_TYPES_TL is referenced by following:

SchemaAPPS
SynonymPON_PRICE_ELEMENT_TYPES_TL