RPC_PACK_COMPVW(SQL View) |
Index Back |
|---|---|
Package components informationView used to retreive package components information |
| SELECT a.SETID , a.PRODUCT_ID , a.PROD_COMPONENT_ID , a.PROD_DISPLAY_ORDER , a.MIN_QTY , a.MAX_QTY , a.QTY_PER , a.DATE_IN_EFFECT , a.DATE_OBSOLETE FROM PS_PRODKIT_COMPS a , PS_PROD_ITEM b , PS_PROD_ITEM c WHERE a.SETID = b.SETID AND a.PRODUCT_ID = b.PRODUCT_ID AND b.CFG_KIT_FLAG = 'M' AND b.EFF_STATUS = 'A' AND a.SETID = c.SETID AND a.PROD_COMPONENT_ID = c.PRODUCT_ID AND c.CFG_KIT_FLAG = 'M' AND c.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 | PROD_COMPONENT_ID | Character(18) | VARCHAR2(18) NOT NULL | Field is used to store components of a product |
| 4 | PROD_DISPLAY_ORDER | Number(2,0) | SMALLINT NOT NULL | We (PeopleSoft) plan on setting a 'Display Order' on the service features in a product. That is how we would decide the order to show the service features. Instead of just doing it alphabetically. |
| 5 | MIN_QTY | Number(10,4) | DECIMAL(9,4) NOT NULL | Minimum Quantity |
| 6 | MAX_QTY | Number(10,4) | DECIMAL(9,4) NOT NULL | Maximum Quantity |
| 7 | QTY_PER | Number(10,4) | DECIMAL(9,4) NOT NULL | Quantity |
| 8 | DATE_IN_EFFECT | Date(10) | DATE | 01/27/2000 RML Added "As of date" label |
| 9 | DATE_OBSOLETE | Date(10) | DATE | Obsolete Date |