SP_OMIBSB_OPRVW

(SQL View)
 Index Back

Ship From IBU Hierarchy

Date Initials Issue Description 081803 dms IR629385001 Turn on search keys

SELECT opr1.oprid , pi.setid , pi.product_id , conv.unit_of_measure , sp.business_unit , pi.inv_item_id , %Round(%DecMult(qa.qty_available, %DecDiv(1, conv.conversion_rate)), 4) , 1 , 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_prod_item pi , ps_sec_setid_opr opr1 , ps_sec_bu_opr opr2 WHERE qa.inv_item_id = pi.inv_item_id AND conv.setid = pi.setid AND conv.inv_item_id = pi.inv_item_id AND sp.business_unit = qa.business_unit AND opr1.setid = pi.setid AND opr2.business_unit = sp.business_unit AND opr1.oprid = opr2.oprid

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

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