SETIDPRODUCT_IDPROD_HOLD_VW(SQL View) |
Index Back |
|---|---|
Product HoldsDate Init. Issue # Description 051304 dms F-KNANN-V59N4 Replace pass to fields |
| SELECT A.SETID ,A.PRODUCT_ID ,B.HOLD_CD ,B.MESSAGE_CD ,A.START_DT ,A.END_DT ,B.PASS_HOLD_TO_BI ,B.PASS_HOLD_TO_ID ,B.PASS_HOLD_TO_IP ,B.PASS_HOLD_TO_IR ,B.PASS_HOLD_TO_IS ,B.PASS_HOLD_TO_IU ,B.PASS_TO_PURCH ,B.INCL_IN_PLAN 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 %EffdtCheck(MESSAGE_TBL C, B, %CurrentDateIn) AND B.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 3 | HOLD_CD | Character(6) | VARCHAR2(6) NOT NULL | Hold Code |
| 4 | MESSAGE_CD | Character(6) | VARCHAR2(6) NOT NULL | Message Code |
| 5 | START_DT | Date(10) | DATE | Start Date |
| 6 | END_DT | Date(10) | DATE | End Date |
| 7 | PASS_HOLD_TO_BI | Character(1) | VARCHAR2(1) NOT NULL | Pass to Billing |
| 8 | PASS_HOLD_TO_ID | Character(1) | VARCHAR2(1) NOT NULL | Pass to Released |
| 9 | PASS_HOLD_TO_IP | Character(1) | VARCHAR2(1) NOT NULL | Pass to Picked/Confirmed |
| 10 | PASS_HOLD_TO_IR | Character(1) | VARCHAR2(1) NOT NULL | Pass to Releasable |
| 11 | PASS_HOLD_TO_IS | Character(1) | VARCHAR2(1) NOT NULL | Pass to Shipped |
| 12 | PASS_HOLD_TO_IU | Character(1) | VARCHAR2(1) NOT NULL | Pass to Unfulfilled |
| 13 | PASS_TO_PURCH | Character(1) | VARCHAR2(1) NOT NULL | Pass to Purchasing |
| 14 | INCL_IN_PLAN | Character(1) | VARCHAR2(1) NOT NULL | Include in Planning |