BC_SHIPTO_COUNT (SQL View)	Index Back
BC Ship to Count BC Ship to Count

BC_SHIPTO_COUNT

(SQL View)

BC Ship to Count

SELECT BO_ID_1 , BO_ID_2 , MAX(CASE WHEN REL_TYPE_ID = 49 OR REL_TYPE_ID = 51 OR REL_TYPE_ID = 61 OR REL_TYPE_ID = 63 THEN 1 ELSE 0 END) FROM PS_BO_REL WHERE REL_TYPE_ID IN (49,51,61,63,48,50,60,62) AND ROLE_TYPE_ID_1 IN (42,46) AND ROLE_TYPE_ID_2 IN (41,45) AND START_DT <= %CurrentDateIn AND END_DT > %CurrentDateIn GROUP BY BO_ID_1, BO_ID_2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID_1 Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID 1

2 BO_ID_2 Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID 2

3 COUNT_TOTAL Number(9,0) DECIMAL(9) NOT NULL Total Count

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID_1	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID 1
2	BO_ID_2	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID 2
3	COUNT_TOTAL	Number(9,0)	DECIMAL(9) NOT NULL	Total Count