View: XTR_CPARTY_ACCT_LOV_V

Product:	XTR - Treasury
Description:	View that gives bank account short name, account number and bank name for counter party
Implementation/DBA Data:	APPS.XTR_CPARTY_ACCT_LOV_V

View Text

SELECT PARTY_CODE CPARTY_CODE
, CURRENCY CURRENCY
, BANK_SHORT_CODE ACCOUNT_REFERENCE
, ACCOUNT_NUMBER ACCOUNT_NUMBER
, BANK_NAME BANK_NAME
FROM XTR_BANK_ACCOUNTS_V
WHERE NVL(AUTHORISED
, 'N') = 'Y'
AND NVL(SETOFF_ACCOUNT_YN
, 'N') != 'Y'
AND BANK_NAME IS NOT NULL UNION SELECT A.PARTY_CODE CPARTY_CODE
, A.CURRENCY CURRENCY
, A.BANK_SHORT_CODE ACCOUNT_REFERENCE
, A.ACCOUNT_NUMBER ACCOUNT_NUMBER
, B.SHORT_NAME BANK_NAME
FROM XTR_BANK_ACCOUNTS_V A
, XTR_PARTY_INFO B
WHERE NVL(A.AUTHORISED
, 'N') = 'Y'
AND NVL(A.SETOFF_ACCOUNT_YN
, 'N') != 'Y'
AND A.BANK_CODE = B.PARTY_CODE (+)
AND A.BANK_NAME IS NULL

Columns