CSH_RCPT_TGM_VW

(SQL View)
 Index Back

Cashier Message Target View

Cashier Message Target View of currently effective short messages.

SELECT MAX(A.BUSINESS_UNIT) ,MAX(A.CASHIER_OFFICE) ,MAX(A.RECEIPT_NBR) ,MAX(A.TARGET_KEY) ,MAX(B.CSH_OFF_LONG_MSG) FROM PS_CSH_OFF_RCPT_L A , PS_CSH_MSG_TARGET B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.CASHIER_OFFICE = B.CASHIER_OFFICE AND A.TARGET_KEY = B.TARGET_KEY AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PS_CSH_MSG_TARGET B2 WHERE B2.BUSINESS_UNIT = B.BUSINESS_UNIT AND B2.CASHIER_OFFICE = B.CASHIER_OFFICE AND B2.TARGET_KEY = B.TARGET_KEY AND B2.EFFDT <= %CurrentDateIn ) GROUP BY A.BUSINESS_UNIT ,A.CASHIER_OFFICE ,A.RECEIPT_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 CASHIER_OFFICE Character(8) VARCHAR2(8) NOT NULL Cashier's Office
3 RECEIPT_NBR Number(12,0) DECIMAL(12) NOT NULL Receipt Number
4 TARGET_KEY Character(10) VARCHAR2(10) NOT NULL Target Key
5 CSH_OFF_LONG_MSG Character(254) VARCHAR2(254) NOT NULL Long Message