DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.ECE_INO_ALLOWANCE_CHARGES_V

Object Details
Object Name: ECE_INO_ALLOWANCE_CHARGES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewEC.ECE_INO_ALLOWANCE_CHARGES_V
Subobject Name:
Status: VALID

View Type

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


This view extracts allowance and charge information
for the outbound Invoice (810/INVOIC) transaction.
The allowance and charges view is used for both header and line level data.

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER (15) Yes Transaction ID
LINE_NUMBER NUMBER
Yes Line Number
LINE_TYPE VARCHAR2 (20) Yes Line Type
CUSTOMER_TRX_LINE_ID NUMBER (15) Yes Customer Transaction Line ID
LINK_TO_CUST_TRX_LINE_ID NUMBER

Link To Customer Transaction Line ID
HEADER_DETAIL_INDICATOR VARCHAR2 (0)
Header Detail Indicator
ALLOWANCE_CHARGE_INDICATOR VARCHAR2 (0)
Allowance Charge Indicator
ALLOWANCE_CHARGE_AMOUNT NUMBER

Detail Allowance/Charge Amount
SPECIAL_CHARGES_CODE VARCHAR2 (0)
Special charges Code
SPECIAL_SERVICES_CODE VARCHAR2 (0)
Special Service Code
METHOD_HANDLING_CODE VARCHAR2 (0)
Method Handling Code
ALLOWANCE_CHARGE_DESC VARCHAR2 (0)
Allowance Charge Desc
AGENCY_QUALIFIER_CODE VARCHAR2 (0)
Agency Qualifier Code
ALLOWANCE_CHARGE_RATE NUMBER

Detail Allowance Charge Rate
ALLOWANCE_CHARGE_PCT_QUALIFIER VARCHAR2 (0)
Allowance Charge PCT Qualifier
ALLOWANCE_CHARGE_PCT NUMBER

Detail Allowance Charge Percent
ALLOWANCE_CHARGE_UOM_CODE VARCHAR2 (0)
Allowance Charge UOM Code
ALLOWANCE_CHARGE_QUANTITY NUMBER

Detail Allowance Charge Quantity
AC_ATTRIBUTE_CATEGORY VARCHAR2 (0)
AC Attribute Category
AC_ATTRIBUTE1 VARCHAR2 (0)
AC Attribute 1
AC_ATTRIBUTE2 VARCHAR2 (0)
AC Attribute 2
AC_ATTRIBUTE3 VARCHAR2 (0)
AC Attribute 3
AC_ATTRIBUTE4 VARCHAR2 (0)
AC Attribute 4
AC_ATTRIBUTE5 VARCHAR2 (0)
AC Attribute 5
AC_ATTRIBUTE6 VARCHAR2 (0)
AC Attribute 6
AC_ATTRIBUTE7 VARCHAR2 (0)
AC Attribute 7
AC_ATTRIBUTE8 VARCHAR2 (0)
AC Attribute 8
AC_ATTRIBUTE9 VARCHAR2 (0)
AC Attribute 9
AC_ATTRIBUTE10 VARCHAR2 (0)
AC Attribute 10
AC_ATTRIBUTE11 VARCHAR2 (0)
AC Attribute 11
AC_ATTRIBUTE12 VARCHAR2 (0)
AC Attribute 12
AC_ATTRIBUTE13 VARCHAR2 (0)
AC Attribute 13
AC_ATTRIBUTE14 VARCHAR2 (0)
AC Attribute 14
AC_ATTRIBUTE15 VARCHAR2 (0)
AC Attribute 15
Query Text

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


SELECT TRANSACTION_ID
,      LINE_NUMBER
,      LINE_TYPE
,      CUSTOMER_TRX_LINE_ID
,      LINK_TO_CUST_TRX_LINE_ID
,      HEADER_DETAIL_INDICATOR
,      ALLOWANCE_CHARGE_INDICATOR
,      ALLOWANCE_CHARGE_AMOUNT
,      SPECIAL_CHARGES_CODE
,      SPECIAL_SERVICES_CODE
,      METHOD_HANDLING_CODE
,      ALLOWANCE_CHARGE_DESC
,      AGENCY_QUALIFIER_CODE
,      ALLOWANCE_CHARGE_RATE
,      ALLOWANCE_CHARGE_PCT_QUALIFIER
,      ALLOWANCE_CHARGE_PCT
,      ALLOWANCE_CHARGE_UOM_CODE
,      ALLOWANCE_CHARGE_QUANTITY
,      AC_ATTRIBUTE_CATEGORY
,      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
FROM APPS.ECE_INO_ALLOWANCE_CHARGES_V;

Dependencies

[top of page]

APPS.ECE_INO_ALLOWANCE_CHARGES_V references the following:

SchemaAPPS
SynonymRA_CUSTOMER_TRX_LINES

APPS.ECE_INO_ALLOWANCE_CHARGES_V is not referenced by any database object