[Home] [Help]
View: PA_TXN_SOURCES_IMPORT_SRS_V
View Text
SELECT DISTINCT NVL(TS.USER_TRANSACTION_SOURCE
, L.MEANING)
, IC.TRANSACTION_SOURCE
, DECODE(TS.USER_TRANSACTION_SOURCE
, NULL
, L.MEANING
, TS.DESCRIPTION)
, '*'
FROM PA_TRANSACTION_XFACE_CONTROL IC
, PA_LOOKUPS L
, PA_TRANSACTION_SOURCES TS
WHERE IC.STATUS = 'PENDING'
AND IC.TRANSACTION_SOURCE = TS.TRANSACTION_SOURCE (+)
AND L.LOOKUP_TYPE = 'TRANSLATION'
AND L.LOOKUP_CODE = 'QP_TRX_SRC_INVALID' UNION SELECT TSX.USER_TRANSACTION_SOURCE
, TSX.TRANSACTION_SOURCE
, TSX.DESCRIPTION
, NULL
FROM PA_TRANSACTION_SOURCES TSX
WHERE NOT EXISTS ( SELECT DISTINCT ICX.TRANSACTION_SOURCE
FROM PA_TRANSACTION_XFACE_CONTROL ICX
WHERE ICX.STATUS = 'PENDING' AND ICX.TRANSACTION_SOURCE = TSX.TRANSACTION_SOURCE)
Columns
Name |
USER_TRANSACTION_SOURCE |
TRANSACTION_SOURCE |
DESCRIPTION |
EXISTS_IN_INTERFACE |