eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AHM_BILLING_CARD_V

Product:	AHM - Hosting Manager(Obsolete)
Description:	This view gives the detail of party credit card information like 'Name, Number, Description, Expiry date etc.'
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT HP.PARTY_ID
, ABAA.BANK_ACCOUNT_NAME
, ABAA.BANK_ACCOUNT_NUM
, ABAA.INACTIVE_DATE
, ABAA.DESCRIPTION
, ABAA.BANK_ACCOUNT_ID
, ABAA.LAST_UPDATE_DATE ACCOUNT_LAST_UPDATE
, ABAUA.BANK_ACCOUNT_USES_ID
, ABAUA.LAST_UPDATE_DATE USES_LAST_UPDATE
, ABAUA.OWNING_PARTY_ID
, HCA.CUST_ACCOUNT_ID
FROM HZ_PARTIES HP
, HZ_CUST_ACCOUNTS HCA
, AP_BANK_ACCOUNTS_ALL ABAA
, AP_BANK_ACCOUNT_USES_ALL ABAUA
WHERE HP.PARTY_ID = HCA.PARTY_ID
AND ABAUA.CUSTOMER_ID = HCA.CUST_ACCOUNT_ID
AND ABAA.BANK_ACCOUNT_ID = ABAUA.EXTERNAL_BANK_ACCOUNT_ID
AND ABAA.BANK_BRANCH_ID = 1
AND NVL(ABAA.INACTIVE_DATE
, SYSDATE+1) >= SYSDATE
AND SYSDATE BETWEEN NVL(ABAUA.START_DATE
, SYSDATE-1)
AND NVL(ABAUA.END_DATE
, SYSDATE+1)
AND ABAUA.CUSTOMER_SITE_USE_ID IS NULL
AND HP.PARTY_TYPE = 'PERSON'
AND ABAUA.PRIMARY_FLAG = 'Y'

Columns

Name
PARTY_ID
BANK_ACCOUNT_NAME
BANK_ACCOUNT_NUM
INACTIVE_DATE
DESCRIPTION
BANK_ACCOUNT_ID
ACCOUNT_LAST_UPDATE
BANK_ACCOUNT_USES_ID
USES_LAST_UPDATE
OWNING_PARTY_ID
CUST_ACCOUNT_ID