View: XTR_COMPANY_ACCT_LOV_V

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

View Text

SELECT A.PARTY_CODE COMPANY_CODE
, A.CURRENCY CURRENCY
, A.BANK_SHORT_CODE BANK_SHORT_CODE
, 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(+)

Columns