AHLD_HLD_CNT_VW

(SQL View)
Index Back

OM Auto Hold Hold Count View

View used in OMHOLD SQR process.

SELECT PROCESS_INSTANCE , BUSINESS_UNIT , ORDER_NO , ORDER_INT_LINE_NO , SCHED_LINE_NBR , COUNT(*) FROM PS_AHLD_HOLD_TMP GROUP BY process_instance , business_unit , order_no , order_int_line_no , sched_line_nbr

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 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
4 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
5 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
6 HOLD_COUNT Number(4,0) SMALLINT NOT NULL Number of Holds