BUSINESS_UNITAUC_PLAN_IDAUC_VERSIONAUC_TASK_NUMAUC_TASK_REQ_NUMEA=Event Approved
EE=Event Ends
EP=Event Posted
ES=Event Starts
EW=Event Awarded
AUC_PLN_RQEV_VW(SQL View) |
Index Back |
|---|---|
Related Event ViewView used by the Event Create component to associate the event to task event requirements. |
| SELECT A.BUSINESS_UNIT , A.AUC_PLAN_ID , A.AUC_VERSION , A.AUC_TASK_NUM , A.AUC_TASK_REQ_NUM , A.AUC_COMPLETE_MTHD FROM PS_AUC_TASK_REQ A , PS_AUC_PLAN_HDR B WHERE A.AUC_REQ_TYPE = 'E' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.AUC_PLAN_ID = B.AUC_PLAN_ID AND A.AUC_VERSION = B.AUC_VERSION AND B.AUC_PLAN_TYPE = 'PL' AND B.AUC_VERSION = ( SELECT MAX(C.AUC_VERSION) FROM PS_AUC_PLAN_HDR C WHERE C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.AUC_PLAN_ID = B.AUC_PLAN_ID AND C.AUC_PLAN_STATUS IN ('AP', 'CO', 'EX', 'PO')) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | AUC_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | Sourcing Planning ID |
| 3 | AUC_VERSION |
Number(5,0) | INTEGER NOT NULL | Event Version |
| 4 | AUC_TASK_NUM |
Number(3,0) | SMALLINT NOT NULL | Task number |
| 5 | AUC_TASK_REQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Task Requirement Number |
| 6 | AUC_COMPLETE_MTHD | Character(2) | VARCHAR2(2) NOT NULL |
Task requirement completion method
EA=Event Approved EE=Event Ends EP=Event Posted ES=Event Starts EW=Event Awarded |