VIEW: APPS.XTR_CPARTY_ACCT_LOV_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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