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: PO.PO_PRICE_DIFF_INTERFACE

Object Details

Object Name:	PO_PRICE_DIFF_INTERFACE
Object Type:	TABLE
Owner:	PO
FND Design Data:	PO.PO_PRICE_DIFF_INTERFACE
Subobject Name:
Status:	VALID

This table holds the price differentials for the rate based
contingent labor lines for requisition lines, PO lines or Blanket
price breaks based on the entity type.
Scope: public
Product: PO
Display Name: PO Price Differential Interface
Category: BUSINESS_ENTITY PO_PRICE_DIFFERENTIAL

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PO_PRICE_DIFF_INTERFACE_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	PRICE_DIFF_INTERFACE_ID
PO_PRICE_DIFF_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	INTERFACE_HEADER_ID
PO_PRICE_DIFF_INTERFACE_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	INTERFACE_LINE_ID
PO_PRICE_DIFF_INTERFACE_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	INTERFACE_LINE_LOCATION_ID
PO_PRICE_DIFF_INTERFACE_N4	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PROCESSING_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PRICE_DIFF_INTERFACE_ID	NUMBER		Yes	The primary key for the price differential table
PRICE_DIFFERENTIAL_NUM	NUMBER			Price differential number
ENTITY_ID	NUMBER			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)		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)		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'.
ENABLED_FLAG	VARCHAR2	(1)		Indicates if the price differential is enabled or not
MIN_MULTIPLIER	NUMBER			Applicable to Blankets only. Minimum value for the multiplier that can be applied to the regular rate designated on the blanket.
MAX_MULTIPLIER	NUMBER			Applicable to Blankets only. Minimum value for the multiplier that can be applied to the regular rate designated on the blanket.
MULTIPLIER	NUMBER			Actual multiplier that is applied to the regular rate on Standard PO or Requisition.
CREATION_DATE	DATE			Standard who column - date when this row was created.
CREATED_BY	NUMBER			Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
INTERFACE_LINE_ID	NUMBER			Interface Line id
INTERFACE_HEADER_ID	NUMBER			Interface header id
PROCESS_STATUS	VARCHAR2	(30)		Status of the interface line
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATED_BY	NUMBER			Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
INTERFACE_LINE_LOCATION_ID	NUMBER			Reference to line location interface
PROCESSING_ID	NUMBER			Identifier for records to be processed by a certain PDOI run
PROCESS_CODE	VARCHAR2	(25)		Processing status

Query Text

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


SELECT PRICE_DIFF_INTERFACE_ID
,      PRICE_DIFFERENTIAL_NUM
,      ENTITY_ID
,      ENTITY_TYPE
,      PRICE_TYPE
,      ENABLED_FLAG
,      MIN_MULTIPLIER
,      MAX_MULTIPLIER
,      MULTIPLIER
,      CREATION_DATE
,      CREATED_BY
,      INTERFACE_LINE_ID
,      INTERFACE_HEADER_ID
,      PROCESS_STATUS
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      INTERFACE_LINE_LOCATION_ID
,      PROCESSING_ID
,      PROCESS_CODE
FROM PO.PO_PRICE_DIFF_INTERFACE;

Dependencies

[top of page]

PO.PO_PRICE_DIFF_INTERFACE does not reference any database object

PO.PO_PRICE_DIFF_INTERFACE is referenced by following:

APPS: PO_PRICE_DIFF_INTERFACE