REQ_ERR_HDR_VW

(SQL View)
Index Back

Par Loc Replen error View

This view retrieves the req loader errors for par replenishment

SELECT BUSINESS_UNIT , INV_CART_ID , CART_COUNT_ID , COUNT_ORDER FROM PS_CART_CT_INF_INV WHERE REPLEN_STATUS='2'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUIN_NONVW

2 INV_CART_ID Character(15) VARCHAR2(15) NOT NULL Par Location ID

Prompt Table: CART_ATTRIB_INV

3 CART_COUNT_ID Number(10,0) DECIMAL(10) NOT NULL Par Location Count ID
4 COUNT_ORDER Signed Number(5,0) DECIMAL(4) NOT NULL Par Location Count Order