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: ViewONT.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:

SchemaAPPS
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL
SynonymOE_PRICE_ADJUSTMENTS
PL/SQL PackageONT_CHARGE_UTIL - show dependent code
APPS.OE_CHARGE_LINES_V is referenced by following:

SchemaAPPS
ViewOEFV_ORDER_CHARGES
Package BodyOE_INVOICE_PUB - show dependent code
Package BodyONT_OEXOEACK_XMLP_PKG - show dependent code
ViewWSH_DSNO_ALLOWANCE_CHARGES_V
Package BodyWSH_FC_INTERFACE_PKG - show dependent code