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_HEADERS_EXT

Object Details

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

Table to capture sales agreement header 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_HEADERS_EXT_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORDER_NUMBER
OE_BLANKET_HEADERS_EXT_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	START_DATE_ACTIVE
OE_BLANKET_HEADERS_EXT_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	END_DATE_ACTIVE
OE_BLANKET_HEADERS_EXT_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ON_HOLD_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
ORDER_NUMBER	NUMBER		Yes	Foregin Key reference to OE_BLANKET_HEADERS_ALL
START_DATE_ACTIVE	DATE			Activation Date of the sales agreement
END_DATE_ACTIVE	DATE			Expiration Date of the sales agreement
ON_HOLD_FLAG	VARCHAR2	(1)		Disallow New Releases: Possible Values:Y/N
BLANKET_MAX_AMOUNT	NUMBER			Maximum Currency amount allowed for sales agreement
BLANKET_MIN_AMOUNT	NUMBER			Minimum currency amount allowed for sales agreement
ENFORCE_PRICE_LIST_FLAG	VARCHAR2	(1)	Yes	Defaulting Source for flag of same name on OE_BLANKET_LINES
OVERRIDE_AMOUNT_FLAG	VARCHAR2	(1)	Yes	Allow Override of Min/max amounts for this sales agreement
RELEASED_AMOUNT	NUMBER			Current released currency amount
RETURNED_AMOUNT	NUMBER			Current returned currency amount
REVISION_CHANGE_REASON_CODE	VARCHAR2	(30)		Stored revision code for sales agreement revision
REVISION_CHANGE_COMMENTS	VARCHAR2	(2000)		Stored Comments for sales agreement revision
REVISION_CHANGE_DATE	DATE			Date revision occurred
ENFORCE_ACCOUNTING_RULE_FLAG	VARCHAR2	(1)	Yes	Defaulting source for flag of same name on OE_BLANKET_LINES
ENFORCE_INVOICING_RULE_FLAG	VARCHAR2	(1)	Yes	Defaulting source for flag of same name on OE_BLANKET_LINES
ENFORCE_SHIP_TO_FLAG	VARCHAR2	(1)	Yes	Defaulting source for flag of same name on OE_BLANKET_LINES
ENFORCE_INVOICE_TO_FLAG	VARCHAR2	(1)	Yes	Defaulting source for flag of same name on OE_BLANKET_LINES
ENFORCE_FREIGHT_TERM_FLAG	VARCHAR2	(1)	Yes	Defaulting source for flag of same name on OE_BLANKET_LINES
ENFORCE_SHIPPING_METHOD_FLAG	VARCHAR2	(1)	Yes	Defaulting source for flag of same name on OE_BLANKET_LINES
ENFORCE_PAYMENT_TERM_FLAG	VARCHAR2	(1)	Yes	Defaulting source for flag of same name on OE_BLANKET_LINES
FULFILLED_AMOUNT	NUMBER			Current fulfilled currency amount
NEW_PRICE_LIST_ID	NUMBER			New price list id
NEW_MODIFIER_LIST_ID	NUMBER			Pricing Modifier list id
DEFAULT_DISCOUNT_PERCENT	NUMBER			Pricing Modifier related discount percent amount
DEFAULT_DISCOUNT_AMOUNT	NUMBER			Pricing Modifier related discount amount

Query Text

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


SELECT ORDER_NUMBER
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ON_HOLD_FLAG
,      BLANKET_MAX_AMOUNT
,      BLANKET_MIN_AMOUNT
,      ENFORCE_PRICE_LIST_FLAG
,      OVERRIDE_AMOUNT_FLAG
,      RELEASED_AMOUNT
,      RETURNED_AMOUNT
,      REVISION_CHANGE_REASON_CODE
,      REVISION_CHANGE_COMMENTS
,      REVISION_CHANGE_DATE
,      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
,      NEW_PRICE_LIST_ID
,      NEW_MODIFIER_LIST_ID
,      DEFAULT_DISCOUNT_PERCENT
,      DEFAULT_DISCOUNT_AMOUNT
FROM ONT.OE_BLANKET_HEADERS_EXT;

Dependencies

[top of page]

ONT.OE_BLANKET_HEADERS_EXT does not reference any database object

ONT.OE_BLANKET_HEADERS_EXT is referenced by following:

APPS: OE_BLANKET_HEADERS_EXT