RPC_PACK_COMPVW

(SQL View)
Index Back

Package components information

View 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