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_PRICE_ADJS_IFACE_ALL

Object Details

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

This is a multi-org open interface table for sales order/line price adjustments. This table stores price adjustment information that is imported from a feeder system into Oracle Order Management using Order Import.
For more information on Order Import refer to the Oracle Manufacturing APIs and Open Interfaces Manual
Scope: public
Product: ONT
Lifecycle: active
Display Name: Sales Order Price Adjustments Interface
Category: BUSINESS_ENTITY ONT_SALES_ORDER

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OE_PRICE_ADJS_IFACE_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REQUEST_ID
OE_PRICE_ADJS_IFACE_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ORDER_SOURCE_ID ORIG_SYS_DOCUMENT_REF ORIG_SYS_LINE_REF ORIG_SYS_SHIPMENT_REF SOLD_TO_ORG_ID SOLD_TO_ORG ORIG_SYS_DISCOUNT_REF CHANGE_SEQUENCE

Columns

Name	Datatype	Length	Mandatory	Comments
ORDER_SOURCE_ID	NUMBER			Order source id
ORIG_SYS_DOCUMENT_REF	VARCHAR2	(50)		Original system document reference
ORIG_SYS_LINE_REF	VARCHAR2	(50)		Original system line reference
ORIG_SYS_SHIPMENT_REF	VARCHAR2	(50)		Original system shipment reference
ORIG_SYS_DISCOUNT_REF	VARCHAR2	(50)		Original system discount reference
CHANGE_SEQUENCE	VARCHAR2	(50)		Change sequence
CHANGE_REQUEST_CODE	VARCHAR2	(30)		Change request code
ORG_ID	NUMBER			Org id
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Application of concurrent program that last updated row.
PROGRAM_ID	NUMBER			Concurrent program that last updated row.
PROGRAM_UPDATE_DATE	DATE			Last date changed by concurrent program
REQUEST_ID	NUMBER			Concurrent request that last changed row
AUTOMATIC_FLAG	VARCHAR2	(1)	Yes	Automatic flag
CONTEXT	VARCHAR2	(30)		Descriptive Flexfield segment
ATTRIBUTE1	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive Flexfield segment
LIST_HEADER_ID	NUMBER			List header id
LIST_NAME	VARCHAR2	(240)		List name
LIST_LINE_ID	NUMBER			List line id
LIST_LINE_TYPE_CODE	VARCHAR2	(30)		List line type code
MODIFIER_MECHANISM_TYPE_CODE	VARCHAR2	(30)		Modifier mechanism type code
MODIFIED_FROM	VARCHAR2	(240)		Modified from
MODIFIED_TO	VARCHAR2	(240)		Modified to
UPDATED_FLAG	VARCHAR2	(1)		Updated flag
UPDATE_ALLOWED	VARCHAR2	(1)		Update allowed
APPLIED_FLAG	VARCHAR2	(1)		Applied flag
CHANGE_REASON_CODE	VARCHAR2	(30)		Change reason code
CHANGE_REASON_TEXT	VARCHAR2	(2000)		Change reason text
DISCOUNT_ID	NUMBER			Discount id
DISCOUNT_LINE_ID	NUMBER			Discount line id
DISCOUNT_NAME	VARCHAR2	(240)		Discount name
PERCENT	NUMBER			Percent
OPERATION_CODE	VARCHAR2	(30)		Operation code
ERROR_FLAG	VARCHAR2	(1)		Error flag
STATUS_FLAG	VARCHAR2	(1)		Status flag
INTERFACE_STATUS	VARCHAR2	(1000)		Interface status
OPERAND	NUMBER			Operand
ARITHMETIC_OPERATOR	VARCHAR2	(30)		Arithmetic operator
PRICING_PHASE_ID	NUMBER			Pricing phase id
ADJUSTED_AMOUNT	NUMBER			Adjusted amount
MODIFIER_NAME	VARCHAR2	(240)		The combination of list_line_number, modifier_name and version_number will be used for improting price_adjustments. This combination will be used for getting the list headers_id adn list_line_id.
LIST_LINE_NUMBER	VARCHAR2	(30)		The combination of list_line_number, modifier_name and version_number will be used for improting price_adjustments. This combination will be used for getting the list headers_id adn list_line_id.
VERSION_NUMBER	VARCHAR2	(30)		The combination of list_line_number, modifier_name and version_number will be used for improting price_adjustments. This combination will be used for getting the list headers_id adn list_line_id.
INVOICED_FLAG	VARCHAR2	(1)		Flag indicating whether the charge is invoiced or not.
ESTIMATED_FLAG	VARCHAR2	(1)		Flag indicating whether the charge amount is estimated or fixed.
INC_IN_SALES_PERFORMANCE	VARCHAR2	(1)		For future use
CHARGE_TYPE_CODE	VARCHAR2	(30)		Type code of charge
CHARGE_SUBTYPE_CODE	VARCHAR2	(30)		Charge Sub Type Code
CREDIT_OR_CHARGE_FLAG	VARCHAR2	(1)		Indicates if the adjustment record is a credit or charge to a customer.
INCLUDE_ON_RETURNS_FLAG	VARCHAR2	(1)		Indicates, if the adjustment is returnable
COST_ID	NUMBER			Reference to the COST record in WSH_FREIGHT_COSTS table.
TAX_CODE	VARCHAR2	(50)		Tax code applied on the Order Line. If the Tax Code associated with an order line is a Tax Group code then this column will store tax code included in the group.
PARENT_ADJUSTMENT_ID	NUMBER			For the future use.
AC_CONTEXT	VARCHAR2	(150)		Additional Charges Descriptive Flexfield structure defining column
AC_ATTRIBUTE1	VARCHAR2	(240)		Additional Charges Descriptive Flexfield segment
AC_ATTRIBUTE2	VARCHAR2	(240)		Additional Charges Descriptive Flexfield segment
AC_ATTRIBUTE3	VARCHAR2	(240)		Additional Charges Descriptive Flexfield segment
AC_ATTRIBUTE4	VARCHAR2	(240)		Additional Charges Descriptive Flexfield segment
AC_ATTRIBUTE5	VARCHAR2	(240)		Additional Charges Descriptive Flexfield segment
AC_ATTRIBUTE6	VARCHAR2	(240)		Additional Charges Descriptive Flexfield segment
AC_ATTRIBUTE7	VARCHAR2	(240)		Additional Charges Descriptive Flexfield segment
AC_ATTRIBUTE8	VARCHAR2	(240)		Additional Charges Descriptive Flexfield segment
AC_ATTRIBUTE9	VARCHAR2	(240)		Additional Charges Descriptive Flexfield segment
AC_ATTRIBUTE10	VARCHAR2	(240)		Additional Charges Descriptive Flexfield segment
AC_ATTRIBUTE11	VARCHAR2	(240)		Additional Charges Descriptive Flexfield segment
AC_ATTRIBUTE12	VARCHAR2	(240)		Additional Charges Descriptive Flexfield segment
AC_ATTRIBUTE13	VARCHAR2	(240)		Additional Charges Descriptive Flexfield segment
AC_ATTRIBUTE14	VARCHAR2	(240)		Additional Charges Descriptive Flexfield segment
AC_ATTRIBUTE15	VARCHAR2	(240)		Additional Charges Descriptive Flexfield segment
OPERAND_PER_PQTY	NUMBER			Operand per pricing quantity.
ADJUSTED_AMOUNT_PER_PQTY	NUMBER			Adjusted amount per pricing quantity.
PRICE_ADJUSTMENT_ID	NUMBER			Foreign Key to OE_PRICE_ADJUSTMENTS. Only applicable for delete operation.
SOLD_TO_ORG	VARCHAR2	(360)		Sold to Org
SOLD_TO_ORG_ID	NUMBER			Sold to Org Id
TAX_RATE_ID	NUMBER	(15)		Key to uniquely identify tax rates.
INST_ID	NUMBER			used in RAC INSTANCE AFFINITY for context setting

Query Text

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


SELECT ORDER_SOURCE_ID
,      ORIG_SYS_DOCUMENT_REF
,      ORIG_SYS_LINE_REF
,      ORIG_SYS_SHIPMENT_REF
,      ORIG_SYS_DISCOUNT_REF
,      CHANGE_SEQUENCE
,      CHANGE_REQUEST_CODE
,      ORG_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      AUTOMATIC_FLAG
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LIST_HEADER_ID
,      LIST_NAME
,      LIST_LINE_ID
,      LIST_LINE_TYPE_CODE
,      MODIFIER_MECHANISM_TYPE_CODE
,      MODIFIED_FROM
,      MODIFIED_TO
,      UPDATED_FLAG
,      UPDATE_ALLOWED
,      APPLIED_FLAG
,      CHANGE_REASON_CODE
,      CHANGE_REASON_TEXT
,      DISCOUNT_ID
,      DISCOUNT_LINE_ID
,      DISCOUNT_NAME
,      PERCENT
,      OPERATION_CODE
,      ERROR_FLAG
,      STATUS_FLAG
,      INTERFACE_STATUS
,      OPERAND
,      ARITHMETIC_OPERATOR
,      PRICING_PHASE_ID
,      ADJUSTED_AMOUNT
,      MODIFIER_NAME
,      LIST_LINE_NUMBER
,      VERSION_NUMBER
,      INVOICED_FLAG
,      ESTIMATED_FLAG
,      INC_IN_SALES_PERFORMANCE
,      CHARGE_TYPE_CODE
,      CHARGE_SUBTYPE_CODE
,      CREDIT_OR_CHARGE_FLAG
,      INCLUDE_ON_RETURNS_FLAG
,      COST_ID
,      TAX_CODE
,      PARENT_ADJUSTMENT_ID
,      AC_CONTEXT
,      AC_ATTRIBUTE1
,      AC_ATTRIBUTE2
,      AC_ATTRIBUTE3
,      AC_ATTRIBUTE4
,      AC_ATTRIBUTE5
,      AC_ATTRIBUTE6
,      AC_ATTRIBUTE7
,      AC_ATTRIBUTE8
,      AC_ATTRIBUTE9
,      AC_ATTRIBUTE10
,      AC_ATTRIBUTE11
,      AC_ATTRIBUTE12
,      AC_ATTRIBUTE13
,      AC_ATTRIBUTE14
,      AC_ATTRIBUTE15
,      OPERAND_PER_PQTY
,      ADJUSTED_AMOUNT_PER_PQTY
,      PRICE_ADJUSTMENT_ID
,      SOLD_TO_ORG
,      SOLD_TO_ORG_ID
,      TAX_RATE_ID
,      INST_ID
FROM ONT.OE_PRICE_ADJS_IFACE_ALL;

Dependencies

[top of page]

ONT.OE_PRICE_ADJS_IFACE_ALL does not reference any database object

ONT.OE_PRICE_ADJS_IFACE_ALL is referenced by following:

ONT: OE_PRICE_ADJS_IFACE_ALL#