HWB_SEARCH_H_VW

(SQL View)
 Index Back

Main Search - Header only

Used when searching for just header level holds 111506 dms 1576506002 Use ORD_HEADER_LOCK in SQL

SELECT H.BUSINESS_UNIT , H.ORDER_NO , 0 , 0 , %subrec(HWB_HEADER_SBR, H) , %Sql(HWB_HEADER1_SBR_VALUE) FROM PS_ORD_HEADER H , PS_ORD_HEADER_LOCK K , PS_CUSTOMER C1 , PS_CUSTOMER C2 , PS_SET_CNTRL_REC SCC WHERE %Sql(HWB_HEADER_WHERE) AND %Sql(HWB_SEARCH_H_NAME_VW_SQL)

# 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 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
6 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
7 OPRID_OWNER Character(30) VARCHAR2(30) NOT NULL Operator id of the owner of a document
8 ORDER_DATE Date(10) DATE Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
9 ORDER_GRP Character(6) VARCHAR2(6) NOT NULL Order Group
10 ORDER_TYPE_CD Character(3) VARCHAR2(3) NOT NULL Order Type
QUO=Sales Quote
SO=Sales Order
11 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
12 HDR_HOLD_DESC Character(50) VARCHAR2(50) NOT NULL Header Holds
13 IS_EDITABLE Character(1) VARCHAR2(1) NOT NULL Editable?
N=No
Y=Yes
14 LIN_HOLD_DESC Character(50) VARCHAR2(50) NOT NULL Line Holds
15 SCH_HOLD_DESC Character(50) VARCHAR2(50) NOT NULL Schedule Holds
16 SOLD_TO_NAME Character(40) VARCHAR2(40) NOT NULL Sold To Customer Name
17 BILL_TO_NAME Character(40) VARCHAR2(40) NOT NULL Bill to customer name
18 HOLD_SUMMARY Character(4) VARCHAR2(4) NOT NULL Current Holds
H=H
HL=H/L
HLS=H/L/S
HS=H/S
L=L
LS=L/S
S=S
19 SELECT_FLAG Character(1) VARCHAR2(1) NOT NULL Selection Flag
N=No
Y=Yes