ST_GROUP_SRCH

(SQL View)
 Index Back

Group Search Record


SELECT A.STOCK_ID , A.ST_GROUP_ID , A.ST_GROUP_DESCR FROM PS_ST_GROUP_TBL A , PS_ST_GRP_PARM_TBL B , PSCLASSDEFN C WHERE A.STOCK_ID = B.STOCK_ID AND A.ST_GROUP_ID = B.ST_GROUP_ID GROUP BY C.CLASSID, A.STOCK_ID, A.ST_GROUP_ID, A.ST_GROUP_DESCR HAVING COUNT(*) = ( SELECT COUNT(*) FROM PS_ST_GRP_PARM_TBL D , PS_ST_GRP_FLD_SEC E WHERE E.ROWSECCLASS = C.CLASSID AND E.RECNAME = D.RECNAME AND E.FIELDNAME = D.FIELDNAME AND D.STOCK_ID = A.STOCK_ID AND D.ST_GROUP_ID = A.ST_GROUP_ID AND E.ACCESSIBLE = 'Y')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Stock ID

Prompt Table: STOCK_TBL

2 ST_GROUP_ID Character(5) VARCHAR2(5) NOT NULL Option Group ID - group of stock options
3 ST_GROUP_DESCR Character(30) VARCHAR2(30) NOT NULL Group ID's description