PO_DEMAND_VW

(SQL View)
 Index Back

Inventory Demand Interface


select process_instance, business_unit, po_stg_type, po_stg_id, line_nbr, sched_nbr, inv_item_id, ds_net_setid, ds_network_code, destin_bu, system_source, qty_avail_flg, sum(qty_requested) from PS_PO_DEMAND_WRK1 where check_inv_qty_flg = 'Y' group by process_instance, business_unit, po_stg_type, po_stg_id, line_nbr, sched_nbr, inv_item_id, ds_net_setid, ds_network_code, destin_bu, system_source, qty_avail_flg

# 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 PO_STG_TYPE Character(1) VARCHAR2(1) NOT NULL Used in conjunction with PO_STG_ID to make a unique key on the stage tables.
O=Other
R=Requisition
4 PO_STG_ID Character(10) VARCHAR2(10) NOT NULL Uniqye key to the PO Staging table
5 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
6 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: MST_ITM_PRPT_VW

8 DS_NET_SETID Character(5) VARCHAR2(5) NOT NULL Distribution Network SetID
9 DS_NETWORK_CODE Character(6) VARCHAR2(6) NOT NULL Distribution Network Code
10 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
11 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
12 QTY_AVAIL_FLG Character(1) VARCHAR2(1) NOT NULL Quantity Available Flag
13 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested