DUN_DELETE_VW2

(SQL View)
 Index Back

Dunning Letter Delete View


SELECT D.CRSPD_SETID , MAX(D.DUN_ID_NUM) , D.CRSPD_CUST_ID FROM PS_DUN_CUST D WHERE D.DELETE_LETTER = 'N' AND (NOT EXISTS ( SELECT 'X' FROM PS_AR33000_TMP R WHERE R.CRSPD_SETID = D.CRSPD_SETID AND R.CRSPD_CUST_ID = D.CRSPD_CUST_ID AND R.DUN_ID_NUM >= D.DUN_ID_NUM AND R.PRINT_COMP = 'N') OR EXISTS ( SELECT 'X' FROM PS_AR33000_TMP R WHERE R.CRSPD_SETID = D.CRSPD_SETID AND R.CRSPD_CUST_ID = D.CRSPD_CUST_ID AND R.DUN_ID_NUM >= D.DUN_ID_NUM AND R.PRINT_COMP = 'Y') ) GROUP BY D.CRSPD_SETID , D.CRSPD_CUST_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CRSPD_SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETCS_NONVW

2 DUN_ID_NUM Number(8,0) INTEGER NOT NULL Dunning Number

Prompt Table: DUNID_DELET_VW2

3 CRSPD_CUST_ID Character(15) VARCHAR2(15) NOT NULL Correspondence Customer

Prompt Table: CRSPD_CUST_D_VW