CUST_CORP_HI_VW

(SQL View)
 Index Back

Corp Cust - No Tree - Hi Bals


SELECT A.CORPORATE_SETID , A.CORPORATE_CUST_ID , C.NAMESHORT , SUM(B.BAL_AMT) FROM PS_CUSTOMER A , PS_CUST_DATA B , PS_CUSTOMER C WHERE A.SETID = ( SELECT C.SETID FROM PS_SET_CNTRL_REC C WHERE C.RECNAME = 'CUSTOMER' AND C.SETCNTRLVALUE = B.BUSINESS_UNIT) AND A.CUST_ID = B.CUST_ID AND C.SETID = A.CORPORATE_SETID AND C.CUST_ID = A.CORPORATE_CUST_ID AND C.CUST_STATUS IN ('A','I') GROUP BY a.corporate_setid, a.corporate_cust_id, c.nameshort HAVING SUM(b.bal_amt) > 100000

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CORPORATE_SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CORPORATE_CUST_ID Character(15) VARCHAR2(15) NOT NULL Corporate Customer

Prompt Table: CUST_CORP_HI_VW

3 NAMESHORT Character(10) VARCHAR2(10) NOT NULL Short Name
4 BAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Item Balance