VIEW: APPS.ECE_CDMO_ALLOWANCE_CHARGES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'