AUC_TSK_BUS_UNITAUC_TSK_REQ_BVW(SQL View) |
Index Back |
|---|---|
Requirement Event Business UntRequirement Event Business Unit |
| SELECT DISTINCT A.AUC_TSK_BUS_UNIT , B.DESCR FROM PS_AUC_TASK_REQ A , PS_AUC_BU_ASSGN_VW B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUSINESS_UNIT <> ' ' AND A.AUC_TSK_BUS_UNIT <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AUC_TSK_BUS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Task requirement Business Unit |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |