[Home] [Help]
View: OZF_X_INVOICES_V
View Text
SELECT TRX_NUMBER
, CUSTOMER_TRX_ID
, INVOICE_CURRENCY_CODE
, AMOUNT_DUE_ORIGINAL
, AMOUNT_DUE_REMAINING
, TRX_DATE
, ACCTD_AMOUNT_DUE_REMAINING
, STATUS
, ORG_ID
, CLASS
, CUST_TRX_TYPE_ID
FROM AR_PAYMENT_SCHEDULES_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)
Columns
Name |
TRX_NUMBER |
CUSTOMER_TRX_ID |
INVOICE_CURRENCY_CODE |
AMOUNT_DUE_ORIGINAL |
AMOUNT_DUE_REMAINING |
TRX_DATE |
ACCTD_AMOUNT_DUE_REMAINING |
STATUS |
ORG_ID |
CLASS |
CUST_TRX_TYPE_ID |