RPC_PRODUCT_VW(SQL View) |
Index Back |
|---|---|
Product informationView used to retreive product information |
| SELECT a.SETID , a.PRODUCT_ID , a.DESCR , a.PROD_TYPE , d.XLATSHORTNAME , b.RB_HLEV_ID , ' ' , c.RB_HLEV_DESCR , b.PROD_MLPB_HCON_FLG , b.PROD_MLPB_DISC_FLG , a.PRICE_KIT_FLAG , a.INSTALLED_PROD , b.OFFER_TYPE , b.BUNDLING_TYPE , f.CONFIG_COUNT_FUNC , 'N' , %CurrentDateIn , %CurrentDateIn , 'N' , %CurrentDateIn , %CurrentDateIn , 'N' , %CurrentDateIn , %CurrentDateIn , 'N' , %CurrentDateIn , %CurrentDateIn , (CASE WHEN x.RBT_ACCOUNT_SEL = 'Y' THEN 'Y' ELSE 'N' END) , (CASE WHEN x.RBT_ACCOUNT_SBIL = 'Y' THEN 'Y' ELSE 'N' END) FROM PS_PROD_ITEM a LEFT OUTER JOIN PS_RBT_PROD_ITEM x ON (x.SETID = a.SETID AND x.PRODUCT_ID = a.PRODUCT_ID) , PS_PROD_MLPB_ITEM b LEFT OUTER JOIN PS_RB_MOD_TYPE_DFN f ON (f.MOD_TYPE_ID = b.MOD_COUNT_TYPE) , PS_RB_HLEV_DFN_TBL c , PSXLATITEM d , PS_RB_MLPB_STRUCT e WHERE a.SETID = b.SETID AND a.PRODUCT_ID = b.PRODUCT_ID AND a.EFF_STATUS = 'A' AND a.CFG_KIT_FLAG = 'M' AND a.SETID = e.SETID AND e.STRUCTURE_ID = c.STRUCTURE_ID AND b.RB_HLEV_ID = c.RB_HLEV_ID AND d.fieldname = 'PROD_TYPE' AND a.PROD_TYPE = d.FIELDVALUE AND d.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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | PROD_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
A new field has been introduced as Product Type to distingush the product types like, Physical Products and Service Products. It is used for PDM enhancement.
AGR=Service Agreement CMT=Commitment Product ENG=Engagement Service PHY=Standard Product PKG=Package Product SUB=Subscription Product SVC=Service Product |
| 5 | PROD_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Field used for storing Multileve product type description |
| 6 | RB_HLEV_ID | Character(20) | VARCHAR2(20) NOT NULL | Field used for storing multilevel structure level id information |
| 7 | RB_CONFIG_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Configurator Component Type ID' field used by Multilevel Component Types definition page
TYP1=Type 1 TYP2=Type 2 TYP3=Type 3 TYP4=Type 4 TYP5=Type 5 TYP6=Type 6 |
| 8 | COMP_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Field used for storing Multileve component type description |
| 9 | PROD_MLPB_HCON_FLG | Character(1) | VARCHAR2(1) NOT NULL | Hide in Configurator' flag used bu Product Definition page for defining new Multilevel Product Bundles |
| 10 | PROD_MLPB_DISC_FLG | Character(1) | VARCHAR2(1) NOT NULL | Disable in Configurator' flag used bu Product Definition page for defining new Multilevel Product Bundles |
| 11 | PRICE_KIT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Price Kit Flag
C=at Component Level T=at Top Level |
| 12 | INSTALLED_PROD | Character(1) | VARCHAR2(1) NOT NULL | Indicates that the product will be tracked as an installed product. |
| 13 | OFFER_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
New Field added to PROD_MLPB_ITEM table to store information about offer type for given product
GRP=Group SHR=Shared |
| 14 | BUNDLING_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Field used for storing information about Product Bundling Type of product definition
DED=Dedicated IND=Individual |
| 15 | OPER_COUNT_FUNC | Character(254) | VARCHAR2(254) NOT NULL | Field used for storing the name of group offer counting function assign to the group offer being exported |
| 16 | COMM_RLON_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Faield used for storing commercial relies on flag |
| 17 | COMM_RLON_BEGIN_DT | Date(10) | DATE | field used for storing Commercial Relies On begin date |
| 18 | COMM_RLON_END_DATE | Date(10) | DATE | field used for storing Commercial Relies On end date |
| 19 | RELIES_ON_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Field used for storing the information flag if any Relies On rule is defined for a product |
| 20 | RELIES_ON_BEGIN_DT | Date(10) | DATE | Field used for storing the earlies begin date of a Relies On rule defined for te product |
| 21 | RELIES_ON_END_DT | Date(10) | DATE | Field used for storing the latest end date of a Relies On rule defined for te product |
| 22 | BRINGS_ON_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Field used for storing the information flag if any Brings On Creation rule is defined for a product |
| 23 | BRINGS_ON_BEGIN_DT | Date(10) | DATE | Field used for storing the earlies begin date of a Brings On Creation rule defined for te product |
| 24 | BRINGS_ON_END_DT | Date(10) | DATE | Field used for storing the latest end date of a Brings On Creation rule defined for te product |
| 25 | BRING_REM_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Field used for storing the information flag if any Brings and Removes rule is defined for a product |
| 26 | BRING_REM_BEGIN_DT | Date(10) | DATE | Field used for storing the earlies begin date of a Brings and Removes rule defined for te product |
| 27 | BRING_REM_END_DT | Date(10) | DATE | Field used for storing the latest end date of a Brings and Removes rule defined for te product |
| 28 | RBT_ACCOUNT_SEL | Character(1) | VARCHAR2(1) NOT NULL | Field used for storing Billing Account Selectable flag value |
| 29 | RBT_ACCOUNT_SBIL | Character(1) | VARCHAR2(1) NOT NULL | Field used for storing Split Billing flag value |