TDS_NETWORK_VW

(SQL View)
 Index Back

Ship From IBU Hierarchy

Date Initials Issue Description 082602 dms DI-DSCANTLA-2 Add item_id, item status fields

SELECT ds.setid , ds.ds_network_code , pi.product_id , conv.unit_of_measure , ds.business_unit_in , pi.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_set_cntrl_rec sc , ps_sp_buin_nonvw sp , ps_inv_item_uom conv , PS_BU_ITEMS_INV qa , ps_prod_item pi , ps_ds_netdet_tbl ds WHERE sc.recname = 'PROD_ITEM' AND sc.setcntrlvalue = ds.business_unit_in AND sp.business_unit = ds.business_unit_in AND qa.business_unit = ds.business_unit_in AND qa.inv_item_id = pi.inv_item_id AND conv.setid = pi.setid AND conv.inv_item_id = pi.inv_item_id AND pi.setid = sc.setid

# 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 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
4 UNIT_MEASURE_ORD Character(3) VARCHAR2(3) NOT NULL Ordering UOM
5 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
7 QTY_AVAILABLE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Available
8 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
9 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
10 ITM_STATUS_FUTURE Character(1) VARCHAR2(1) NOT NULL Item Status Future
1=Active
2=Hold
3=Discontinue
4=Inactive
11 ITM_STAT_DT_FUTURE Date(10) DATE Item Date Future