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

TABLE: PO.PO_PRICE_DIFFERENTIALS

Object Details
Object Name: PO_PRICE_DIFFERENTIALS
Object Type: TABLE
Owner: PO
FND Design Data: TablePO.PO_PRICE_DIFFERENTIALS
Subobject Name:
Status: VALID


This table holds the price diferentials information for the rate-based lines on Requisitions, Standard Purchase Orders and Global Agreements.
Using Price Differentials, you can capture different pay rates for different price types (such as Overtime, Weekend, and Holiday) as "multipliers" of the price specified on the line or price-break. Then the actual pay rate may be obtained by multiplying the line or price-break price by the multiplier for the price type defined on the line or price-break.
For Global Agreements, price differentials can be defined at both the line and price break levels. For Standard Purchase Orders and Requisitions, price differentials may only be defined at the line level.
[Note 1]
On Blanet Agreements, you can capture the minimum and maximum multiplier for each price differential type (e.g. Holiday, Overtime, Weekend). During the resource finalization process in iProcurement, you will be able to choose a multiplier value that falls within the minimum and maximum multiplier values. The minimum multiplier is mandatory whereas the maximium multiplier is optional . You can capture the minimum price for a given state/legal regulation in the minimum multiplier field. The maximum multiplier, when specified, cannot be less than the stated minimum multiplier.
[Note 2]
On Standard Purchase Orders, you can specify only a single value for the multiplier for each of the price differential types. If the PO line is tied to a Blanket Agreement, you can only have price differentials that are "enabled" on the Blanket, and the specified value for the multiplier should be within the corresponding blanket line price (or price-break price) differential minimum and maximum multipliers.
[Note 3]
You cannot create multiple price differential records of the same type for a line or price-break record. For example, if you have already defined a Price Type of "OVERTIME" for a Standard Purchase Order line, you cannot define another Price Differential record of the type "OVERTIME" for the same PO line again.
On Standard Purchase Order lines which reference a Global Agreement, you can only define Price Differential records with the Price Types that are enabled on the referenced Global Agreement.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_PRICE_DIFFERENTIALS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRICE_DIFFERENTIAL_ID
PO_PRICE_DIFFERENTIALS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnENTITY_ID
ColumnENTITY_TYPE
ColumnPRICE_TYPE
Columns
Name Datatype Length Mandatory Comments
PRICE_DIFFERENTIAL_ID NUMBER
Yes Unique identifier for this price differential. Primary key for this table.
PRICE_DIFFERENTIAL_NUM NUMBER
Yes Price differential line number
ENTITY_ID NUMBER
Yes ID of the Req Line, PO Line, Blanket Line, or Price Break to which this price differential belongs. References PO_REQUISITION_LINES_ALL.requisition_line_id, PO_LINES_ALL.po_line_id, OR PO_LINE_LOCATIONS_ALL.line_location_id.
ENTITY_TYPE VARCHAR2 (30) Yes The type of the entity this price differential is tied to. Possible values can be: 'REQ LINE', 'PO LINE', 'BLANKET LINE', 'PRICE BREAK'
PRICE_TYPE VARCHAR2 (30) Yes Type of rate for which this price differential will be applied (e.g. STANDARD, HOLIDAY, OVERTIME, WEEKEND). Comes from FND_LOOKUP_VALUES.lookup_code with lookup_type, 'PRICE DIFFERENTIALS'. Also see Note 3.
ENABLED_FLAG VARCHAR2 (1)
Indicates if the price differential is enabled
MIN_MULTIPLIER NUMBER

Applicable to Blankets only. Minimum value for the multiplier that can be applied to the regular rate designated on the blanket. Also see Note 1.
MAX_MULTIPLIER NUMBER

Applicable to Blankets only. Maximum value for the multiplier that can be applied to the regular rate designated on the blanket. Also see Note 1.
MULTIPLIER NUMBER

Actual multiplier that is applied to the regular rate on Standard PO or Requisition. Also see Note 2.
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
Query Text

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


SELECT PRICE_DIFFERENTIAL_ID
,      PRICE_DIFFERENTIAL_NUM
,      ENTITY_ID
,      ENTITY_TYPE
,      PRICE_TYPE
,      ENABLED_FLAG
,      MIN_MULTIPLIER
,      MAX_MULTIPLIER
,      MULTIPLIER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM PO.PO_PRICE_DIFFERENTIALS;

Dependencies

[top of page]

PO.PO_PRICE_DIFFERENTIALS does not reference any database object

PO.PO_PRICE_DIFFERENTIALS is referenced by following:

SchemaAPPS
SynonymPO_PRICE_DIFFERENTIALS