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_PRSL_AUD

Object Details

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

This table is not used in 11i and may be dropped in a later release.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OP_PRSL_AUDI1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	CHANGEPRSL_ID
OP_PRSL_AUD_PK	NORMAL	UNIQUE	APPS_TS_ARCHIVE	CHANGEPRSL_LINE_ID
OP_PRSL_AUD_UK	NORMAL	UNIQUE	APPS_TS_ARCHIVE	PRESALES_ORDLINE_ID CHANGEPRSL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CHANGEPRSL_LINE_ID	NUMBER	(10)	Yes	Uniquely identifies a change to a presales order (profile,BSO) line
PRICEREAS_CODE	VARCHAR2	(4)	Yes	Defines reason for price change.
CHANGEPRSL_ID	NUMBER	(10)	Yes	Reference to all changes under this id.
NET_PRICE	NUMBER		Yes	Previous per unit net price.
CHANGE_COMMENT	VARCHAR2	(70)	Yes	Freeform text - comment for line changed.
ORDER_QTY1	NUMBER		Yes	Previous order quantity in order_um1.
BSO_MINTOTALQTY1	NUMBER		Yes	Previous blanket order minimum total quantity in order_um1.
BSO_MAXTOTALQTY1	NUMBER		Yes	Previous blanket order maximum total quantity in order_um1.
BSO_MINTOTALVALUE	NUMBER		Yes	Preivous blanket order minimum total value.
BSO_MAXTOTALVALUE	NUMBER		Yes	Previous blanket order maximum total value.
ORDER_UM1	VARCHAR2	(4)	Yes	Unit of measure for all order quantities.
AVAILABILITY_LEADTIME	NUMBER		Yes	Previous availability leadtime quoted to customer (in days).
TRANSIT_LEADTIME	NUMBER		Yes	Previous transit leadtime quoted to customer (in days).
QC_GRADE_WANTED	VARCHAR2	(4)	Yes	Previous qc grade wanted.
SHIPPER_CODE	VARCHAR2	(4)	Yes	Previous shipper code.
SHIPCUST_ID	NUMBER	(10)	Yes	Previous ship-to customer.
SHIPADDR_ID	NUMBER	(10)	Yes	Previous ship-to address.
TO_WHSE	VARCHAR2	(4)	Yes	Previous to-warehouse.
FROM_WHSE	VARCHAR2	(4)	Yes	Previous from-warehouse (for interplant/transfer and consignment customers only).
PRESALES_ORDLINE_ID	NUMBER	(10)	Yes	Reference to presales order line which has been changed.
STATUS_IND	NUMBER	(5)	Yes	Previous status of presales order line.
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
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.

Query Text

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


SELECT CHANGEPRSL_LINE_ID
,      PRICEREAS_CODE
,      CHANGEPRSL_ID
,      NET_PRICE
,      CHANGE_COMMENT
,      ORDER_QTY1
,      BSO_MINTOTALQTY1
,      BSO_MAXTOTALQTY1
,      BSO_MINTOTALVALUE
,      BSO_MAXTOTALVALUE
,      ORDER_UM1
,      AVAILABILITY_LEADTIME
,      TRANSIT_LEADTIME
,      QC_GRADE_WANTED
,      SHIPPER_CODE
,      SHIPCUST_ID
,      SHIPADDR_ID
,      TO_WHSE
,      FROM_WHSE
,      PRESALES_ORDLINE_ID
,      STATUS_IND
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DELETE_MARK
FROM GML.OP_PRSL_AUD;

Dependencies

[top of page]

GML.OP_PRSL_AUD does not reference any database object

GML.OP_PRSL_AUD is referenced by following:

GML: OP_PRSL_AUD#