REQ_ERR_INQ_VW(SQL View) |
Index Back |
|---|---|
Par Loc Replen error ViewThis view retrieves the req loader errors for par replenishment |
| SELECT A.BUSINESS_UNIT , A.INV_CART_ID , A.CART_COUNT_ID , A.COUNT_ORDER , A.INV_ITEM_ID , A.COMPARTMENT , A.CART_COUNT_QTY , A.UNIT_OF_MEASURE , A.QTY_OPTIMAL , A.LAST_OPRID , A.LAST_DTTM_UPDATE , A.CART_COUNT_STATUS ,A.BUSINESS_UNIT_PO ,A.REPLEN_STATUS ,( SELECT REPLACE(REPLACE( REPLACE(REPLACE(MSG.MESSAGE_TEXT ,'%1' ,A.MESSAGE_PARM1) ,'%2' ,A.MESSAGE_PARM2) ,'%3' ,A.MESSAGE_PARM3) ,'%4' ,A.MESSAGE_PARM4) FROM PSMSGCATDEFN MSG WHERE A.MESSAGE_SET_NBR = MSG.MESSAGE_SET_NBR AND A.MESSAGE_NBR = MSG.MESSAGE_NBR) FROM PS_CART_CT_INF_INV A WHERE A.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 |
| 5 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: MST_ITM_PRPT_VW |
| 6 | COMPARTMENT |
Character(10) | VARCHAR2(10) NOT NULL | Compartment |
| 7 | CART_COUNT_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Par Location Count Quantity |
| 8 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: INV_STCK_UOM_VW |
| 9 | QTY_OPTIMAL | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Optimal Qty |
| 10 | LAST_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Response Operator |
| 11 | LAST_DTTM_UPDATE | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 12 | CART_COUNT_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Par Location Count Status
1=Unprocessed 2=In Process 3=In Error 4=Complete 5=Interim Hold Default Value: 1 Prompt Table: PSXLATITEM |
| 13 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 14 | REPLEN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Replenish Status
1=Ready 2=Error 3=In Process 4=Processed 5=Canceled |
| 15 | ERRORMSG | Character(254) | VARCHAR2(254) NOT NULL | Error Message field |