[Home] [Help]
View: AR_TA_CASHAPP_OB
Product: | AR - Receivables |
Description: | SINGLE_ORG view |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT ORG_ID
, TRANSMISSION_REQUEST_ID
, BATCH_NAME
, PAYMENT_SCHEDULE_ID
, CURRENT_OPEN_BALANCE
FROM AR_TA_CASHAPP_OB_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 |
ORG_ID |
TRANSMISSION_REQUEST_ID |
BATCH_NAME |
PAYMENT_SCHEDULE_ID |
CURRENT_OPEN_BALANCE |