[Home] [Help]
View: PA_TRANSACTION_XFACE_CONTROL
Product: | PA - Projects |
Description: | Single-Org - Retrofitted |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT TRANSACTION_SOURCE
, BATCH_NAME
, STATUS
, INTERFACE_ID
, TRANSACTION_COUNT
, ORG_ID
, SYSTEM_LINKAGE_FUNCTION
, INTERMEDIATE_FLAG
, PROCESSED_COUNT
FROM PA_TRANSACTION_XFACE_CTRL_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)
Columns
Name |
TRANSACTION_SOURCE |
BATCH_NAME |
STATUS |
INTERFACE_ID |
TRANSACTION_COUNT |
ORG_ID |
SYSTEM_LINKAGE_FUNCTION |
INTERMEDIATE_FLAG |
PROCESSED_COUNT |