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: GML.OP_PRCE_EFF

Object Details

Object Name:	OP_PRCE_EFF
Object Type:	TABLE
Owner:	GML
FND Design Data:	GML.OP_PRCE_EFF
Subobject Name:
Status:	VALID

Pricing effectivities determine if a price list, contract or charge is active and for whom. Pricelists and contracts must have effectivities to be used in the pricing logic in Order Entry. Charges may optionally have effectivities. Charges with effectivities will be automatically applied to an order or order line by the pricing logic in Order Entry; charges without effectivities may be manually entered on an order.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OP_PRCE_EFFI1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORGN_CODE CUSTPRICE_CLASS CUST_ID TERRITORY START_DATE END_DATE PREFERENCE EFFECTIVITY_TYPE PRICELIST_ID CONTRACT_ID CHARGE_ID
OP_PRCE_EFF_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PRICEFF_ID
OP_PRCE_EFFF1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTRACT_ID
OP_PRCE_EFFF2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRICELIST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PRICEFF_ID	NUMBER	(10)	Yes	Surrogate id to uniquely identify a pricing effectivity.
ORGN_CODE	VARCHAR2	(4)		Organization code to which effectivity applies. FK to sy_orgn_mst. When contains NULL value, denotes 'ALL" condition.
PROMOTION_ID	NUMBER	(10)		Promotion which applies to this effectivity. For future use.
CUST_ID	NUMBER	(15)		Customer (bill-to, ship-to, sold-to) to which effectivity applies. FK to op_cust_mst. When contains NULL value, denotes 'ALL" condition.
INACTIVE_IND	NUMBER	(5)	Yes	Defaults to 0 which means "active". Value of 1 means inactive.
LISTPRICE_IND	NUMBER	(5)	Yes	Indicates if pricelist is a List Price. Value of 0 = pricelist is not List; value of 1 = pricelist is "list". Used to determine field list_price on order detail.
CUSTPRICE_CLASS	VARCHAR2	(8)		Customer price class (grouping of customers) to which effectivity applies. When contains NULL value, denotes 'ALL" condition. FK to op_cprc_cls.
DELETE_MARK	NUMBER		Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
TRANS_CNT	NUMBER	(10)		Not currently used
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
TERRITORY	VARCHAR2	(8)		Customer territory to which effectivity applies. When contains NULL value, denotes 'ALL" condition.
START_DATE	DATE		Yes	Start/effective date of this effectivity. Defaults to "today".
END_DATE	DATE		Yes	Expiration/end date of effectivity. Defaults to sy$max_date.
PREFERENCE	NUMBER	(5)	Yes	Preference of effectivity use. Higher number indicates more preferred effectivity. Lower number indicates lower preference. User assigns preference.
EFFECTIVITY_TYPE	NUMBER	(5)	Yes	Type of effectivity record. Valid values are: 0 = item pricing/pricelist effectivity, 1 = contract effectivity, 2 =promotions effectivity (for future use) , 3 = charge effectivity
PRICELIST_ID	NUMBER	(10)		Pricelist to which this effectivity applies. FK to op_prce_mst.
CONTRACT_ID	NUMBER	(10)		Effectivity applies to contract. FK to op_cntr_hdr.
CHARGE_ID	NUMBER	(10)		Charge code to which this effectivity applies.
OPM_CUST_ID	NUMBER	(10)		Used by OM users only. Stores customer id to op_cust_mst (OPM customer table) for historical purposes.

Query Text

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


SELECT PRICEFF_ID
,      ORGN_CODE
,      PROMOTION_ID
,      CUST_ID
,      INACTIVE_IND
,      LISTPRICE_IND
,      CUSTPRICE_CLASS
,      DELETE_MARK
,      TEXT_CODE
,      TRANS_CNT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TERRITORY
,      START_DATE
,      END_DATE
,      PREFERENCE
,      EFFECTIVITY_TYPE
,      PRICELIST_ID
,      CONTRACT_ID
,      CHARGE_ID
,      OPM_CUST_ID
FROM GML.OP_PRCE_EFF;

Dependencies

[top of page]

GML.OP_PRCE_EFF does not reference any database object

GML.OP_PRCE_EFF is referenced by following:

APPS: OP_PRCE_EFF