FO_ORDR_SUPP_VW

(SQL View)

SELECT A.BUSINESS_UNIT ,A.SO_ID ,D.FEE_SCHEDULE ,B.FEE_PCT FROM PS_RS_SO_HDR A , PS_POTENTIAL_INCME B , PS_SET_CNTRL_REC C , PS_RS_SO_LINE D , PS_FO_ORDER_TYPE H WHERE A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.USER_ORDER_TYPE = H.USER_ORDER_TYPE AND H.ORDER_TYPE = 'C' AND A.SYSTEM_SOURCE = 'STF' AND A.SO_ID = D.SO_ID AND A.BUSINESS_UNIT = C.SETCNTRLVALUE AND C.RECNAME = 'POTENTIAL_INCME' AND C.SETID = B.SETID AND B.FEE_SCHEDULE = D.FEE_SCHEDULE AND B.SALARY_RANGE_MIN = ( SELECT MAX(E.SALARY_RANGE_MIN) FROM PS_POTENTIAL_INCME E WHERE E.SETID = C.SETID AND E.FEE_SCHEDULE = D.FEE_SCHEDULE AND E.SALARY_RANGE_MIN <= (D.SALARY_RANGE_MAX + D.INITIAL_COMP)) AND B.SALARY_RANGE_MAX = ( SELECT MIN(SALARY_RANGE_MAX) FROM PS_POTENTIAL_INCME F WHERE F.SETID = C.SETID AND F.FEE_SCHEDULE = D.FEE_SCHEDULE AND F.SALARY_RANGE_MAX >= (D.SALARY_RANGE_MAX + D.INITIAL_COMP))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 ORDER_ID Character(25) VARCHAR2(25) NOT NULL Order ID

3 FEE_SCHEDULE Character(50) VARCHAR2(50) NOT NULL Fee Schedule

4 FEE_PCT Number(6,2) DECIMAL(5,2) NOT NULL Fee Percentage

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	ORDER_ID	Character(25)	VARCHAR2(25) NOT NULL	Order ID
3	FEE_SCHEDULE	Character(50)	VARCHAR2(50) NOT NULL	Fee Schedule
4	FEE_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Fee Percentage