View: ECE_INO_ALLOWANCE_CHARGES_V

Product:	EC - e-Commerce Gateway
Description:	This view extracts allowance and charge informationfor the outbound Invoice (810/INVOIC) transaction.The allowance and charges view is used for both header and line level data.@rep:scope private@rep:product AR@rep:lifecycle active@rep:displ
Implementation/DBA Data:	APPS.ECE_INO_ALLOWANCE_CHARGES_V

View Text

SELECT RCTL.CUSTOMER_TRX_ID TRANSACTION_ID
, RCTL.LINE_NUMBER LINE_NUMBER
, RCTL.LINE_TYPE LINE_TYPE
, RCTL.CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, NVL(RCTL.LINK_TO_CUST_TRX_LINE_ID
, 0) LINK_TO_CUST_TRX_LINE_ID
, TO_CHAR(NULL) HEADER_DETAIL_INDICATOR
, TO_CHAR(NULL) ALLOWANCE_CHARGE_INDICATOR
, TO_NUMBER(NULL) ALLOWANCE_CHARGE_AMOUNT
, TO_CHAR(NULL) SPECIAL_CHARGES_CODE
, TO_CHAR(NULL) SPECIAL_SERVICES_CODE
, TO_CHAR(NULL) METHOD_HANDLING_CODE
, TO_CHAR(NULL) ALLOWANCE_CHARGE_DESC
, TO_CHAR(NULL) AGENCY_QUALIFIER_CODE
, TO_NUMBER(NULL) ALLOWANCE_CHARGE_RATE
, TO_CHAR(NULL) ALLOWANCE_CHARGE_PCT_QUALIFIER
, TO_NUMBER(NULL) ALLOWANCE_CHARGE_PCT
, TO_CHAR(NULL) ALLOWANCE_CHARGE_UOM_CODE
, TO_NUMBER(NULL) ALLOWANCE_CHARGE_QUANTITY
, TO_CHAR(NULL) AC_ATTRIBUTE_CATEGORY
, TO_CHAR(NULL) AC_ATTRIBUTE1
, TO_CHAR(NULL) AC_ATTRIBUTE2
, TO_CHAR(NULL) AC_ATTRIBUTE3
, TO_CHAR(NULL) AC_ATTRIBUTE4
, TO_CHAR(NULL) AC_ATTRIBUTE5
, TO_CHAR(NULL) AC_ATTRIBUTE6
, TO_CHAR(NULL) AC_ATTRIBUTE7
, TO_CHAR(NULL) AC_ATTRIBUTE8
, TO_CHAR(NULL) AC_ATTRIBUTE9
, TO_CHAR(NULL) AC_ATTRIBUTE10
, TO_CHAR(NULL) AC_ATTRIBUTE11
, TO_CHAR(NULL) AC_ATTRIBUTE12
, TO_CHAR(NULL) AC_ATTRIBUTE13
, TO_CHAR(NULL) AC_ATTRIBUTE14
, TO_CHAR(NULL) AC_ATTRIBUTE15
FROM RA_CUSTOMER_TRX_LINES RCTL
WHERE RCTL.LINE_TYPE = 'FREIGHT'

Columns