SETIDPRODUCT_IDPROD_HOLD_VW(SQL View) |
Index Back |
|---|---|
Product Holds |
| SELECT A.SETID ,A.PRODUCT_ID ,B.HOLD_CD ,B.MESSAGE_CD ,A.START_DT ,A.END_DT ,B.PASS_THRU_INV ,B.INCL_IN_PLAN ,b.pass_to_purch FROM PS_PROD_MSG A , PS_MESSAGE_TBL B , PS_SET_CNTRL_REC C WHERE C.RECNAME='MESSAGE_TBL' AND C.SETCNTRLVALUE=A.SETID AND B.SETID = C.SETID AND A.MESSAGE_CD = B.MESSAGE_CD AND B.MESSAGE_ACTION = 'H' AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_MESSAGE_TBL C WHERE C.SETID = B.SETID AND C.MESSAGE_CD = B.MESSAGE_CD AND C.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 2 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 3 | HOLD_CD | Character(6) | VARCHAR2(6) NOT NULL | This field determine the hold code of an item. |
| 4 | MESSAGE_CD | Character(6) | VARCHAR2(6) NOT NULL | Message Code |
| 5 | START_DT | Date(10) | DATE | Start date field to store start date value. |
| 6 | END_DT | Date(10) | DATE | This field stores the end date values. |
| 7 | PASS_THRU_INV | Character(1) | VARCHAR2(1) NOT NULL | Process Thru Inventory |
| 8 | INCL_IN_PLAN | Character(1) | VARCHAR2(1) NOT NULL | Include in Planning |
| 9 | PASS_TO_PURCH | Character(1) | VARCHAR2(1) NOT NULL | Pass to Purchasing |