SETID_SWINV_ITEM_ID_SWSUB_PRIORITY_NBRITM_SUB_VW2(SQL View) |
Index Back |
|---|
| SELECT A.SETID, A.INV_ITEM_ID, A.SUB_PRIORITY_NBR, A.SUB_ITM_ID, B.DESCR254_MIXED FROM PS_SUBSTITUTE_ITM A, PS_PURCH_ITEM_ATTR B WHERE A.SETID = B.SETID AND A.INV_ITEM_ID = B.INV_ITEM_ID AND (A.EFFDT_FROM IS NULL or A.EFFDT_FROM <= %CURRENTDATEIN) AND (A.EFFDT_TO IS NULL or A.EFFDT_TO >= %CURRENTDATEIN) AND A.USE_FOR_PROCURE = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID_SW |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | INV_ITEM_ID_SW |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | SUB_PRIORITY_NBR |
Number(3,0) | SMALLINT NOT NULL | 03/30/99 laj...CN#EN800-1.0 This field was "cloned" for BOM mass maintenance. Any field attribute changes here need also to be to done to en_new_sub_pri_nbr. |
| 4 | SUB_ITM_ID | Character(18) | VARCHAR2(18) NOT NULL | 11/30/99 RML Added label "Substitute" |
| 5 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |