GM_CUST_LOC_VW (SQL View)	Index Back
Grants LOC Bill-To Sponsors View of all customers who are Grants Letter of Credit sponsors, marked as 'bill to', and not marked as 'Prospects'.

GM_CUST_LOC_VW

(SQL View)

Grants LOC Bill-To Sponsors

View of all customers who are Grants Letter of Credit sponsors, marked as 'bill to', and not marked as 'Prospects'.

SELECT DISTINCT B.SETID , B.CUST_ID , B.NAME1 FROM PS_CUSTOMER A , PS_CUSTOMER B WHERE A.SETID = B.SETID AND A.GM_LOC_SPONSOR_ID = B.CUST_ID AND B.BILL_TO_FLG = 'Y' AND B.CUST_LEVEL <> 'P'

# 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 SPONSOR_ID Character(15) VARCHAR2(15) NOT NULL SPONSOR_ID

3 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1