HWB_CURRHLD_VW

(SQL View)

SELECT H.BUSINESS_UNIT , H.HOLD_CD , %Round(AVG(%DecDiv(%DateTimeDiff(H.LASTUPDDTTM,%CurrentDateTimeIn),1440)),2) FROM %Table(ORD_HOLD) H , %Table(ORD_HEADER) O WHERE H.BUSINESS_UNIT = O.BUSINESS_UNIT AND H.ORDER_NO = O.ORDER_NO AND O.ORDER_TYPE_CD = 'SO' AND H.HOLD_LEVEL <> 'W' AND H.EFF_STATUS = 'A' GROUP BY H.BUSINESS_UNIT , H.HOLD_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 HOLD_CD Character(6) VARCHAR2(6) NOT NULL Hold Code

3 DAYS_ON_HOLD Number(13,2) DECIMAL(12,2) NOT NULL Days on Hold

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	HOLD_CD	Character(6)	VARCHAR2(6) NOT NULL	Hold Code
3	DAYS_ON_HOLD	Number(13,2)	DECIMAL(12,2) NOT NULL	Days on Hold