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_DRAFT

Object Details

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

PO_PRICE_DIFF_DRAFT stores draft changes to PO Price Differentials that have not been accepted by buyer. A record in this table contains the proposed values for the corresponding record in the transaction table PO_PRICE_DIFFERENTIALS. When the draft changes are accepted, the record is moved to PO_PRICE_DIFFERENTIALS. Changes from buyer are automatically accepted.
PO_PRICE_DIFF_DRAFT contains all columns from PO_PRICE_DIFFERENTIALS, as well as the following additional columns:
1. DRAFT_ID: Primary key of the table; Foreign key to PO_DRAFTS table;
2. CHANGE_ACCEPTED_FLAG: Acceptance status of the draft record;
3. DELETE_FLAG: Flag indicating whether the corresponding record in transaction table should be deleted when the draft change is accepted.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PO_PRICE_DIFF_DRAFT_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PRICE_DIFFERENTIAL_ID DRAFT_ID
PO_PRICE_DIFF_DRAFT_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ENTITY_ID ENTITY_TYPE PRICE_TYPE DRAFT_ID
PO_PRICE_DIFF_DRAFT_N0	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DRAFT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DRAFT_ID	NUMBER		Yes	Primary key of the table; Foreign key to PO_DRAFTS table.
CHANGE_ACCEPTED_FLAG	VARCHAR2	(1)		Acceptance status of the draft record.
DELETE_FLAG	VARCHAR2	(1)		Flag indicating whether the corresponding record in transaction table should be deleted when the draft change is accepted.
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).
CHANGE_STATUS	VARCHAR2	(30)		Modification change status

Query Text

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


SELECT DRAFT_ID
,      CHANGE_ACCEPTED_FLAG
,      DELETE_FLAG
,      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
,      CHANGE_STATUS
FROM PO.PO_PRICE_DIFF_DRAFT;

Dependencies

[top of page]

PO.PO_PRICE_DIFF_DRAFT does not reference any database object

PO.PO_PRICE_DIFF_DRAFT is referenced by following:

PO: PO_PRICE_DIFF_DRAFT#