IN_FW_SEL_10_VW

(SQL View)
Index Back

FW: available list of actions

View displaying avaialble list of action for a template id

SELECT TEMPLATE_ID ,IN_TM_CATEGORY ,IN_TM_SUB_CATEGORY FROM PS_IN_TM_OPR_SCAT WHERE IN_TM_CODE = 'FULFIL_WRKBENCH'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template

Prompt Table: IN_FW_SEL_6_VW

2 IN_TM_CATEGORY Character(15) VARCHAR2(15) NOT NULL Template Category
3 IN_TM_SUB_CATEGORY Character(15) VARCHAR2(15) NOT NULL Template Subcategory