GM_CNTCT_EF_VW

(SQL View)
 Index Back

Grants Crrnt EffDt Contacts

...copy of CUST_CNCT_EF_VW, but replacing CUST_ID with BILL_TO_CUST_ID

select a.setid, a.cust_id, a.cntct_seq_num, a.name1, a.title from PS_CUST_CONTACT a where a.effdt = (select max(effdt) from PS_CUST_CONTACT where setid=a.setid and cust_id=a.cust_id and cntct_seq_num=a.cntct_seq_num and effdt <= %currentdatein and eff_status='A')

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

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

Prompt Table: CUSTOMER

3 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

Prompt Table: CUST_CONTACT

4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
5 TITLE Character(35) VARCHAR2(35) NOT NULL Title