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.

[Home] [Help]

View: IBE_RA_CUSTOMER_TRX_V

Product:	IBE - iStore
Description:	This view is used to get the Invoice header details in Post sales interaction with Customer in iStore, this view is bases on ra_customrer_trx
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT CT.ROWID ROW_ID
, CT.TRX_NUMBER TRX_NUMBER
, CT.TRX_DATE TRX_DATE
, CT.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, AL_CLASS.MEANING AL_CLASS_MEANING
, CT.PURCHASE_ORDER CT_PURCHASE_ORDER
, CT.WAYBILL_NUMBER WAYBILL_NUMBER
, SUM(DECODE(PS.AMOUNT_DUE_REMAINING
, 0
, NULL
, TRUNC(SYSDATE) - PS.DUE_DATE)) DAYS_PAST_DUE
, MIN(PS.DUE_DATE) DUE_DATE
, TO_CHAR(PS.AMOUNT_DUE_ORIGINAL
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CT.INVOICE_CURRENCY_CODE
, 30)) AMOUNT_DUE_ORIGINAL
, TO_CHAR(PS.AMOUNT_DUE_REMAINING
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CT.INVOICE_CURRENCY_CODE
, 30)) AMOUNT_DUE_REMAINING
, TO_CHAR(PS.AMOUNT_LINE_ITEMS_ORIGINAL
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CT.INVOICE_CURRENCY_CODE
, 30)) AMOUNT_LINE_ITEMS_ORIGINAL
, TO_CHAR(PS.TAX_ORIGINAL
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CT.INVOICE_CURRENCY_CODE
, 30)) TAX_ORIGINAL
, TO_CHAR(PS.FREIGHT_ORIGINAL
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CT.INVOICE_CURRENCY_CODE
, 30)) FREIGHT_ORIGINAL
, TO_CHAR(PS.AMOUNT_ADJUSTED
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CT.INVOICE_CURRENCY_CODE
, 30)) AMOUNT_ADJUSTED
, TO_CHAR(PS.AMOUNT_APPLIED
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CT.INVOICE_CURRENCY_CODE
, 30)) AMOUNT_APPLIED
, TO_CHAR(PS.AMOUNT_CREDITED
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CT.INVOICE_CURRENCY_CODE
, 30)) AMOUNT_CREDITED
, TO_CHAR(PS.DISCOUNT_TAKEN_EARNED
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CT.INVOICE_CURRENCY_CODE
, 30)) DISCOUNT_TAKEN_EARNED
, CT.SHIP_VIA SHIP_VIA
, ACCT.PARTY_ID PARTY_ID
, CT.BILL_TO_SITE_USE_ID CUSTOMER_SITE_USE_ID
, CT.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, PS.CLASS CLASS
, PS.STATUS STATUS
, PS.RECEIPT_CONFIRMED_FLAG RECEIPT_CONFIRMED_FLAG
, ACCT.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
FROM AR_PAYMENT_SCHEDULES PS
, RA_CUSTOMER_TRX CT
, AR_LOOKUPS AL_CLASS
, HZ_CUST_ACCOUNTS ACCT
WHERE PS.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID
AND PS.CLASS = AL_CLASS.LOOKUP_CODE
AND AL_CLASS.LOOKUP_TYPE = 'INV/CM'
AND CT.BILL_TO_CUSTOMER_ID = ACCT.CUST_ACCOUNT_ID GROUP BY CT.CUSTOMER_TRX_ID
, CT.ROWID
, CT.TRX_NUMBER
, CT.TRX_DATE
, CT.INVOICE_CURRENCY_CODE
, AL_CLASS.MEANING
, CT.PURCHASE_ORDER
, CT.WAYBILL_NUMBER
, CT.SHIP_VIA
, ACCT.PARTY_ID
, CT.BILL_TO_SITE_USE_ID
, PS.AMOUNT_DUE_REMAINING
, PS.DUE_DATE
, PS.AMOUNT_DUE_ORIGINAL
, PS.AMOUNT_DUE_REMAINING
, PS.AMOUNT_LINE_ITEMS_ORIGINAL
, PS.TAX_ORIGINAL
, PS.FREIGHT_ORIGINAL
, PS.AMOUNT_ADJUSTED
, PS.AMOUNT_APPLIED
, PS.AMOUNT_CREDITED
, PS.DISCOUNT_TAKEN_EARNED
, PS.CLASS
, PS.STATUS
, PS.RECEIPT_CONFIRMED_FLAG
, ACCT.CUST_ACCOUNT_ID

Columns

Name
ROW_ID
TRX_NUMBER
TRX_DATE
INVOICE_CURRENCY_CODE
AL_CLASS_MEANING
CT_PURCHASE_ORDER
WAYBILL_NUMBER
DAYS_PAST_DUE
DUE_DATE
AMOUNT_DUE_ORIGINAL
AMOUNT_DUE_REMAINING
AMOUNT_LINE_ITEMS_ORIGINAL
TAX_ORIGINAL
FREIGHT_ORIGINAL
AMOUNT_ADJUSTED
AMOUNT_APPLIED
AMOUNT_CREDITED
DISCOUNT_TAKEN_EARNED
SHIP_VIA
PARTY_ID
CUSTOMER_SITE_USE_ID
CUSTOMER_TRX_ID
CLASS
STATUS
RECEIPT_CONFIRMED_FLAG
CUST_ACCOUNT_ID