RPC_PACK_HEADVW(SQL View) |
Index Back |
|---|---|
Package header informationView used to retreive package header information |
| SELECT a.SETID , a.PRODUCT_ID , a.MIN_COMP , a.MAX_COMP ,a.DATE_IN_EFFECT ,a.date_obsolete FROM PS_PRODKIT_HEADER a , PS_PROD_ITEM b WHERE a.SETID = b.SETID AND a.PRODUCT_ID = b.PRODUCT_ID AND b.CFG_KIT_FLAG = 'M' AND b.EFF_STATUS = 'A' |
| # | 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 | MIN_COMP | Number(17,0) | DECIMAL(17) NOT NULL | Minimum Component Quantity |
| 4 | MAX_COMP | Number(17,0) | DECIMAL(17) NOT NULL | Maximum Component Quantity |
| 5 | DATE_IN_EFFECT | Date(10) | DATE | 01/27/2000 RML Added "As of date" label |
| 6 | DATE_OBSOLETE | Date(10) | DATE | Obsolete Date |