SP_OMDNSB_NONVW

(SQL View)
 Index Back

Ship From IBU Hierarchy

Date Initials Issue Description 022002 dms 11697201 Replace tds_network_vw 081803 dms IR629385001 Turn on search keys

SELECT DISTINCT ds.setid , ds.ds_network_code , conv.setid , pi.product_id , conv.unit_of_measure , ds.business_unit_in , qa.inv_item_id , %Round(%DecMult(qa.qty_available, %DecDiv(1, conv.conversion_rate)), 4) , ds.priority_nbr , qa.itm_status_current , qa.itm_status_future , qa.itm_stat_dt_future FROM ps_sp_buin_nonvw sp , ps_inv_item_uom conv , PS_BU_ITEMS_INV qa , ps_ds_netdet_tbl ds , ps_prod_item pi WHERE sp.business_unit = ds.business_unit_in AND qa.business_unit = ds.business_unit_in AND qa.inv_item_id = conv.inv_item_id AND pi.setid = conv.setid AND pi.inv_item_id = conv.inv_item_id

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

2 DS_NETWORK_CODE Character(6) VARCHAR2(6) NOT NULL Distribution Network Code
3 SETID_PRODUCT Character(5) VARCHAR2(5) NOT NULL Product SetID
4 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
5 UNIT_MEASURE_ORD Character(3) VARCHAR2(3) NOT NULL Ordering UOM
6 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
8 QTY_AVAILABLE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Available
9 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
10 ITM_STATUS_CURRENT Character(1) VARCHAR2(1) NOT NULL Item Status Current
1=Active
2=Hold
3=Discontinue
4=Inactive
5=Pending Approval
6=Denied Approval
7=Under Initialization
11 ITM_STATUS_FUTURE Character(1) VARCHAR2(1) NOT NULL Item Status Future
1=Active
2=Hold
3=Discontinue
4=Inactive
12 ITM_STAT_DT_FUTURE Date(10) DATE Item Date Future