ORD_PROD_ALT_VW

(SQL View)
 Index Back

Product Alternates Priority

Date Initials Issue # Description 06.26.03 DEG 598033002 Removed DNC

SELECT a.setid ,a.product_id ,d.business_unit ,a.priority_nbr ,b.unit_of_measure ,a.product_id_alt ,%Round(%DecMult(d.qty_available, %DecDiv(1, e.conversion_rate)), 4) ,a.qty_per ,a.interchangable ,a.start_dt ,a.end_dt , 0 ,f.descr FROM PS_BU_ITEMS_INV d , ps_inv_item_uom e , ps_prod_item f , ps_prod_uom b , ps_prod_alt a WHERE a.setid=b.setid AND a.product_id_alt=b.product_id AND f.setid=b.setid AND f.product_id=b.product_id AND d.inv_item_id=f.inv_item_id AND e.setid=f.setid AND e.inv_item_id=f.inv_item_id AND e.unit_of_measure=b.unit_of_measure AND f.eff_status='A' AND a.setid=( SELECT setid FROM ps_set_cntrl_rec WHERE recname='PROD_ALT' AND setcntrlvalue=d.business_unit)

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

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: PROD_ITEM

3 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
4 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
5 UNIT_MEASURE_ORD Character(3) VARCHAR2(3) NOT NULL Ordering UOM
6 PRODUCT_ID_ALT Character(18) VARCHAR2(18) NOT NULL Alternate Product ID

Prompt Table: %EDITTABLE

7 QTY_AVAILABLE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Available
8 QTY_PER Number(10,4) DECIMAL(9,4) NOT NULL Quantity
9 INTERCHANGABLE Character(1) VARCHAR2(1) NOT NULL Interchangeable

Y/N Table Edit

Default Value: Y

10 START_DT Date(10) DATE NOT NULL Start Date

Default Value: %date

11 END_DT Date(10) DATE NOT NULL End Date
12 HOLD_COUNT Number(4,0) SMALLINT NOT NULL Number of Holds
13 DESCR Character(30) VARCHAR2(30) NOT NULL Description