SPB_EMAIL_P_REC (SQL View)	Index Back
Records by activity List all records used in the pages of the component associated with the business activity.

SPB_EMAIL_P_REC

(SQL View)

Records by activity

List all records used in the pages of the component associated with the business activity.

SELECT s.ACTIVITYNAME ,f.RECNAME FROM PSMENUITEM m , PSSTEPDEFN s , PSPNLGROUP c , PSPNLFIELD f WHERE m.MENUNAME = s.MENUNAME AND m.BARNAME = s.BARNAME AND m.ITEMNAME = s.ITEMNAME AND c.PNLGRPNAME = m.PNLGRPNAME AND f.PNLNAME = c.PNLNAME AND f.RECNAME <> ' ' AND s.ACTIVITYNAME LIKE 'SP%' UNION SELECT s.ACTIVITYNAME ,f.RECNAME FROM PSMENUITEM m , PSSTEPDEFN s , PSPNLGROUP c , PSPNLFIELD f ,PSPNLFIELD fs WHERE m.MENUNAME = s.MENUNAME AND m.BARNAME = s.BARNAME AND m.ITEMNAME = s.ITEMNAME AND c.PNLGRPNAME = m.PNLGRPNAME AND (f.PNLNAME = fs.SUBPNLNAME AND fs.PNLNAME = c.PNLNAME AND fs.FIELDTYPE=11) AND f.RECNAME <> ' ' AND s.ACTIVITYNAME LIKE 'SP%' GROUP BY s.ACTIVITYNAME,f.RECNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
Prompt Table: SP_WF_NOTIFY

2 RECORDNAME Character(15) VARCHAR2(15) NOT NULL Record Name
01=MASTER_ITEM_EC
02=INV_ITEMS_EC
03=BU_ITM_INV_EC
04=BU_ITM_WTVL_EC
05=ITEM_SUPPLIER_EC
06=ITM_SUPP_LOC_EC
07=ITM_VNDR_UOM_EC
08=ITM_VND_UMPR_EC
09=INV_ITM_UOM_EC
10=PUR_ITM_ATTR_EC
13=EN_REVISION_EC
14=ITEM_MFG_GPO_EC
15=ITEM_MFG_EC
16=ITEM_CAT_EC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ACTIVITYNAME	Character(30)	VARCHAR2(30) NOT NULL	Name of a Business Process Activity (see PSACTIVITYDEFN). Prompt Table: SP_WF_NOTIFY
2	RECORDNAME	Character(15)	VARCHAR2(15) NOT NULL	Record Name 01=MASTER_ITEM_EC 02=INV_ITEMS_EC 03=BU_ITM_INV_EC 04=BU_ITM_WTVL_EC 05=ITEM_SUPPLIER_EC 06=ITM_SUPP_LOC_EC 07=ITM_VNDR_UOM_EC 08=ITM_VND_UMPR_EC 09=INV_ITM_UOM_EC 10=PUR_ITM_ATTR_EC 13=EN_REVISION_EC 14=ITEM_MFG_GPO_EC 15=ITEM_MFG_EC 16=ITEM_CAT_EC