RBF_ATM_RPRD_VW

(SQL View)
 Index Back

ATM Card Replacement Products

Retrieves valid replacement Products for a given ATM Card Product

SELECT PR.SETID , PR.PRODUCT_ID , PR.PRODUCT_ID_ALT , PI.DESCR FROM PS_PROD_ITEM PI , PS_PROD_RELATIONS PR WHERE PI.SETID = PR.SETID AND PI.PRODUCT_ID = PR.PRODUCT_ID_ALT AND PI.ORDERABLE = 'N' AND PR.PROD_REL_TYPE = 'REPL' AND PR.START_DT <= %CurrentDateIn AND (PR.END_DT > %CurrentDateIn OR PR.END_DT IS NULL)

  • Related Language Record: RBF_ATM_RPRDLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID_PRODUCT Character(5) VARCHAR2(5) NOT NULL Product SetID
    2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    3 PRODUCT_ID_NEW Character(18) VARCHAR2(18) NOT NULL New Product ID
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description