VIEW: APPS.PA_TXN_SOURCES_IMPORT_SRS_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)