RBF_ACCT_ATM_VW

(SQL View)
 Index Back

View for getting ATM Cards

View for getting ATM Cards associated with the account

SELECT AU.FIN_ACCOUNT_ID , AC.ATM_CARD_NO , AC.ATM_CARD_STATUS , AC.BO_ID_CUST , N1.BO_NAME , AC.BO_ID_CONTACT , N2.BO_NAME FROM PS_RBF_ATM_CARD AC , PS_RBF_ATM_USAGE AU , PS_BO_NAME N1 , PS_BO_NAME N2 WHERE AC.ATM_CARD_NO = AU.ATM_CARD_NO AND AC.BO_ID_CUST = N1.BO_ID AND N1.PRIMARY_IND = 'Y' AND AC.BO_ID_CONTACT = N2.BO_ID (+) AND N2.PRIMARY_IND (+) = 'Y'

  • Parent record: RBF_FIN_ACCOUNT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIN_ACCOUNT_ID Character(20) VARCHAR2(20) NOT NULL Financial Account Number
    2 ATM_CARD_NO Number(16,0) DECIMAL(16) NOT NULL ATM Card Number
    3 ATM_CARD_STATUS Character(3) VARCHAR2(3) NOT NULL Status of an ATM Card, stored as a translate value
    ACT=Active
    CNC=Cancelled
    ERR=Error
    INA=Inactive
    PRC=Processing
    SSP=Suspended
    4 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
    5 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
    6 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
    7 BO_NAME_1 Character(50) VARCHAR2(50) NOT NULL BO Name 1