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_CHG

Object Details

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

This table contains Charges (discounts, freight, allowances) for an entire order profile and/or individual order profile lines. The table is populated during setup of an order profile.
If the charge applies to the entire order profile, then the presales_ord line_id is NULL. If the charge applies to a specific order profile line, then the presales_ord line_id contains the appropriate value.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OP_PRSL_CHG_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CHARGE_LINE_ID
OP_PRSL_CHGI1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRESALES_ORD_ID PRESALES_ORDLINE_ID CHARGE_LINE_NO
OP_PRSL_CHGI2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRESALES_ORDLINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CHARGE_LINE_ID	NUMBER	(10)	Yes	Unique surrogate id for charge line; alternate primary key is presales_ord_id + presales_ordline_id + charge_line_no
CHARGE_ID	NUMBER	(10)	Yes	Surrogate key for charge code.
BILLABLE_IND	NUMBER	(5)	Yes	Defaults from op_chrg_mst and can be overridden by user. Value of 0 means that charge is not billed to bill-to customer; value of 1 means that charge is billed to bill-to customer.
CHARGE_RATE	NUMBER			Charge rate, if charge is a percentage. Defaults from op_chrg_mst and can be overridden by user.
CHARGE_LINE_AMOUNT	NUMBER			Flat charge amount which defaults from op_chrg_mst if charge is a flat amount. Can be overridden by user.
CHARGE_UNIT_AMOUNT	NUMBER			Per unit amount if charge is based on a quantity. Defaults from op_chrg_mst.
CHARGE_UOM	VARCHAR2	(4)		Unit of measure for the charge_unit_amount. Field is required if charge_unit_amount is entered. Defaults from op_chrg_mst.
PRESALES_ORDLINE_ID	NUMBER	(10)		Surrogate key from op_prsl_dtl; links charges to a presales order line.
CREATION_DATE	DATE		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
CREATED_BY	NUMBER	(15)	Yes	Standard who column
TRANS_CNT	NUMBER	(10)		Not currently used
DELETE_MARK	NUMBER	(5)	Yes	Flag to indicate logical deletion of record; 0 means active record; 1 means "deleted" record.
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
PRESALES_ORD_ID	NUMBER	(10)	Yes	Surrogate key from op_prsl_hdr
CHARGE_LINE_NO	NUMBER	(5)	Yes	Unique line number assigned by system.

Query Text

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


SELECT CHARGE_LINE_ID
,      CHARGE_ID
,      BILLABLE_IND
,      CHARGE_RATE
,      CHARGE_LINE_AMOUNT
,      CHARGE_UNIT_AMOUNT
,      CHARGE_UOM
,      PRESALES_ORDLINE_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      TRANS_CNT
,      DELETE_MARK
,      TEXT_CODE
,      PRESALES_ORD_ID
,      CHARGE_LINE_NO
FROM GML.OP_PRSL_CHG;

Dependencies

[top of page]

GML.OP_PRSL_CHG does not reference any database object

GML.OP_PRSL_CHG is referenced by following:

APPS: OP_PRSL_CHG