FO_CUST_BI_VW

(SQL View)
 Index Back

Customer Billing Addresses


SELECT DISTINCT a.setid , a.cust_id , c.name1 , a.descr FROM ps_cust_addr_seq a , PS_CUST_ADDRESS b , ps_customer c WHERE a.setid = b.setid AND a.cust_id= b.cust_id AND a.setid = c.setid AND a.cust_id = c.cust_id AND a.address_seq_num = b.address_seq_num AND a.bill_to_addr = 'Y' AND a.sold_to_addr = 'Y' AND b.effdt = ( SELECT MAX(effdt) FROM PS_CUST_ADDRESS WHERE setid=b.setid AND cust_id=b.cust_id AND address_seq_num=b.address_seq_num AND effdt <= %CurrentDateIn) AND b.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 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description