HWB_SHLDAMT_VW

(SQL View)
 Index Back

Sched Amounts on hold


SELECT DISTINCT H.BUSINESS_UNIT , H.ORDER_NO , S.ORDER_INT_LINE_NO , S.SCHED_LINE_NBR , O.SOLD_TO_CUST_ID , S.CURRENCY_CD_BASE , %Round(%DecMult(S.NET_UNIT_PRICE_BSE, S.QTY_SCHEDULED), 4) FROM PS_ORD_HOLD H , PS_ORD_HEADER O , PS_ORD_SCHEDULE S WHERE H.BUSINESS_UNIT = O.BUSINESS_UNIT AND H.ORDER_NO = O.ORDER_NO AND H.BUSINESS_UNIT = S.BUSINESS_UNIT AND H.ORDER_NO = S.ORDER_NO AND ((H.ORDER_NO = S.ORDER_NO AND H.ORDER_INT_LINE_NO = 0 AND H.SCHED_LINE_NBR = 0) OR (H.ORDER_INT_LINE_NO <> 0 AND H.ORDER_INT_LINE_NO = S.ORDER_INT_LINE_NO AND H.SCHED_LINE_NBR = 0) OR (H.ORDER_INT_LINE_NO <> 0 AND H.SCHED_LINE_NBR <> 0 AND H.ORDER_INT_LINE_NO = S.ORDER_INT_LINE_NO AND H.SCHED_LINE_NBR = S.SCHED_LINE_NBR)) AND H.EFF_STATUS = 'A' AND H.HOLD_LEVEL <> 'W' AND O.ORDER_TYPE_CD = 'SO' AND S.ORD_SCH_STATUS IN ('O','P')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
5 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
6 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
7 HOLD_AMT Number(32,4) DECIMAL(31,4) NOT NULL Hold Amount