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]

VIEW: APPS.OE_CHARGE_LINES_V

Object Details

Object Name:	OE_CHARGE_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ONT.OE_CHARGE_LINES_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

It is used to get Freight and Special charges applied on Order or Order Line. This view is based on the oe_price_adjustments table giving details like charge amount, invoice status etc.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
HEADER_ID	NUMBER		Yes	Order Header
LINE_ID	NUMBER			ORDER LINE_ID
CHARGE_ID	NUMBER		Yes	System generated Primary key
CHARGE_NAME	VARCHAR2	(4000)		Type code of Charge
CHARGE_AMOUNT	NUMBER			Charge Amount
CURRENCY_CODE	VARCHAR2	(15)		Currency Code
CONVERSION_RATE	NUMBER			Conversion rate
CONVERSION_DATE	DATE			Conversion date
CONVERSION_TYPE_CODE	VARCHAR2	(30)		Comversion type code
FIXED_FLAG	VARCHAR2	(1)		Flag to indicate if the user has modied this row
INVOICED_FLAG	VARCHAR2	(1)		Flag indicating whether the charge is invoiced or not.
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
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
INTERCO_INVOICED_FLAG	VARCHAR2	(1)		Inter Company invoice flag.
ORG_ID	NUMBER			Operating unit
ORDER_NUMBER	NUMBER		Yes	User-visible number of the order
ORDERED_DATE	DATE			Ordered date
FOB_POINT_CODE	VARCHAR2	(30)		FOB point code
SOURCE_SYSTEM_CODE	VARCHAR2	(30)		Source system which has generated this adjustment
ESTIMATED_FLAG	VARCHAR2	(1)		Estimated or fixed.
INVOICED_AMOUNT	NUMBER			Freight charge amount interfaced to receivables.

Query Text

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


SELECT HEADER_ID
,      LINE_ID
,      CHARGE_ID
,      CHARGE_NAME
,      CHARGE_AMOUNT
,      CURRENCY_CODE
,      CONVERSION_RATE
,      CONVERSION_DATE
,      CONVERSION_TYPE_CODE
,      FIXED_FLAG
,      INVOICED_FLAG
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      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
,      INTERCO_INVOICED_FLAG
,      ORG_ID
,      ORDER_NUMBER
,      ORDERED_DATE
,      FOB_POINT_CODE
,      SOURCE_SYSTEM_CODE
,      ESTIMATED_FLAG
,      INVOICED_AMOUNT
FROM APPS.OE_CHARGE_LINES_V;

Dependencies

[top of page]

APPS.OE_CHARGE_LINES_V references the following:

APPS: OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL; OE_PRICE_ADJUSTMENTS; ONT_CHARGE_UTIL - show dependent code

APPS.OE_CHARGE_LINES_V is referenced by following:

APPS: OEFV_ORDER_CHARGES; OE_INVOICE_PUB - show dependent code; ONT_OEXOEACK_XMLP_PKG - show dependent code; WSH_DSNO_ALLOWANCE_CHARGES_V; WSH_FC_INTERFACE_PKG - show dependent code