IN_DEL_LOCK_VW

(SQL View)
 Index Back

Inv Demand Row Locking


SELECT D.BUSINESS_UNIT , D.DEMAND_SOURCE , D.SOURCE_BUS_UNIT , D.ORDER_NO , D.ORDER_INT_LINE_NO , D.SCHED_LINE_NBR , D.INV_ITEM_ID , D.DEMAND_LINE_NO , D.PRODUCT_ID , D.DELIVERY_ID , CASE WHEN K.PROCESS_INSTANCE IS NULL THEN 0 ELSE K.PROCESS_INSTANCE END , V.DELIVERY_STATUS , V.FRT_RATE_STATUS , V.MANIFEST_STATUS , V.PREF_CARRIER_FLAG , CASE D.DEMAND_SOURCE WHEN 'OM' THEN H.BACKGROUND_REQD ELSE 'N' END , K.PRCSNAME %Sql(IN_DEL_LOCK_VW_WHERE)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUIN_NONVW

2 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
3 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit

Prompt Table: SP_BU_FS_NONVW

4 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
5 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
6 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: BU_ITM_INV_VW2

8 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
9 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
10 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
11 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
12 DELIVERY_STATUS Character(2) VARCHAR2(2) NOT NULL Delivery Status
00=Pending for Demand
10=Pending for Quote
20=Open
60=Closed for Shipment
70=Delivery Completed
90=Canceled
99=Unassigned
13 FRT_RATE_STATUS Character(2) VARCHAR2(2) NOT NULL Rate Status
00=None
10=Requested
20=Received
14 MANIFEST_STATUS Character(2) VARCHAR2(2) NOT NULL Manifest Status
00=None
10=Requested
20=Received
15 PREF_CARRIER_FLAG Character(1) VARCHAR2(1) NOT NULL Preferred Carrier flag
N=No Preferred Carrier
Y=Preferred Carrier
16 BACKGROUND_REQD Character(1) VARCHAR2(1) NOT NULL Background Process Required
E=OMBCKEND Req'd
N=No
P=Pricing Req'd
Y=Yes
17 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name