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: ONT.OE_BLANKET_LINES_EXT

Object Details

Object Name:	OE_BLANKET_LINES_EXT
Object Type:	TABLE
Owner:	ONT
FND Design Data:	ONT.OE_BLANKET_LINES_EXT
Subobject Name:
Status:	VALID

Table to capture sales agreement line details, specific to sales agreement functionality

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OE_BLANKET_LINES_EXT_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LINE_ID
OE_BLANKET_LINES_EXT_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	START_DATE_ACTIVE
OE_BLANKET_LINES_EXT_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	END_DATE_ACTIVE
OE_BLANKET_LINES_EXT_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORDER_NUMBER LINE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
ORDER_NUMBER	NUMBER		Yes	User Visible number of the sales agreement
START_DATE_ACTIVE	DATE			Activation date of sales agreement line
END_DATE_ACTIVE	DATE			Expiration Date of sales agreement line
BLANKET_LINE_MAX_AMOUNT	NUMBER			Maximum total currency amount allowed
BLANKET_LINE_MIN_AMOUNT	NUMBER			Minimum total currency amount allowed
ENFORCE_PRICE_LIST_FLAG	VARCHAR2	(1)	Yes	Enforces price list on release line
RELEASED_AMOUNT	NUMBER			Current released currency amount
RETURNED_AMOUNT	NUMBER			Current returned currency amount
LINE_NUMBER	NUMBER			User Visible number of sales agreement line
MAX_RELEASE_AMOUNT	NUMBER			Maximum release currency amount allowed
MIN_RELEASE_AMOUNT	NUMBER			Minimum release currency amount allowed
BLANKET_MAX_QUANTITY	NUMBER			Maximum total quantity allowed
BLANKET_MIN_QUANTITY	NUMBER			Minimum total quantity allowed
MAX_RELEASE_QUANTITY	NUMBER			Maximum release quantity
MIN_RELEASE_QUANTITY	NUMBER			Minimum release quantity
OVERRIDE_RELEASE_CONTROLS_FLAG	VARCHAR2	(1)	Yes	Allow Override of min/max release values
OVERRIDE_BLANKET_CONTROLS_FLAG	VARCHAR2	(1)	Yes	Allow override of min/max values
FULFILLED_QUANTITY	NUMBER			Current fulfilled quantity
RETURNED_QUANTITY	NUMBER			Current returned quantity
RELEASED_QUANTITY	NUMBER			Current released quantity
QP_LIST_LINE_ID	NUMBER			Foreign Key reference to QP_LIST_LINES_VL the price list.
LINE_ID	NUMBER			Foreign Key reference to OE_BLANKET_LINES_ALL
ENFORCE_ACCOUNTING_RULE_FLAG	VARCHAR2	(1)	Yes	Enforces accounting rule on release line
ENFORCE_INVOICING_RULE_FLAG	VARCHAR2	(1)	Yes	Enforces Invoicing Rule on Release line
ENFORCE_SHIP_TO_FLAG	VARCHAR2	(1)	Yes	Enforces Ship To on release line
ENFORCE_INVOICE_TO_FLAG	VARCHAR2	(1)	Yes	Enforces Invoice To on release Line
ENFORCE_FREIGHT_TERM_FLAG	VARCHAR2	(1)	Yes	Enforces Freight Term on Release Line
ENFORCE_SHIPPING_METHOD_FLAG	VARCHAR2	(1)	Yes	Enforces Shipping Method on release line
ENFORCE_PAYMENT_TERM_FLAG	VARCHAR2	(1)	Yes	Enforces Payment Term on release line
FULFILLED_AMOUNT	NUMBER			Current fulfilled currency amount
MODIFIER_LIST_LINE_ID	NUMBER			Identifier for discount line created inline from this sales agreement line

Query Text

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


SELECT ORDER_NUMBER
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      BLANKET_LINE_MAX_AMOUNT
,      BLANKET_LINE_MIN_AMOUNT
,      ENFORCE_PRICE_LIST_FLAG
,      RELEASED_AMOUNT
,      RETURNED_AMOUNT
,      LINE_NUMBER
,      MAX_RELEASE_AMOUNT
,      MIN_RELEASE_AMOUNT
,      BLANKET_MAX_QUANTITY
,      BLANKET_MIN_QUANTITY
,      MAX_RELEASE_QUANTITY
,      MIN_RELEASE_QUANTITY
,      OVERRIDE_RELEASE_CONTROLS_FLAG
,      OVERRIDE_BLANKET_CONTROLS_FLAG
,      FULFILLED_QUANTITY
,      RETURNED_QUANTITY
,      RELEASED_QUANTITY
,      QP_LIST_LINE_ID
,      LINE_ID
,      ENFORCE_ACCOUNTING_RULE_FLAG
,      ENFORCE_INVOICING_RULE_FLAG
,      ENFORCE_SHIP_TO_FLAG
,      ENFORCE_INVOICE_TO_FLAG
,      ENFORCE_FREIGHT_TERM_FLAG
,      ENFORCE_SHIPPING_METHOD_FLAG
,      ENFORCE_PAYMENT_TERM_FLAG
,      FULFILLED_AMOUNT
,      MODIFIER_LIST_LINE_ID
FROM ONT.OE_BLANKET_LINES_EXT;

Dependencies

[top of page]

ONT.OE_BLANKET_LINES_EXT does not reference any database object

ONT.OE_BLANKET_LINES_EXT is referenced by following:

APPS: OE_BLANKET_LINES_EXT