RSP_TSK_TPL_VW(SQL View) |
Index Back |
---|---|
Task Group Templates for PlansThis view is used to associate Task Group Templates to Planning Template. When a new plan is created from a template, tasks from task group template will be defaulted on the new plan. |
SELECT TASK_GRP_TPL_ID , DESCR FROM PS_RB_TGRP_TPL WHERE ACTIVE_FLG = 'Y' AND APPLICATION_USAGE = 'RSP' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | TASK_GRP_TPL_ID | Character(10) | VARCHAR2(10) NOT NULL | Task Group Template ID primary key |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |