BUSINESS_UNITAUC_PLAN_IDAUC_VERSIONAUC_TSK_BUS_UNITPrompt Table: AUC_BU_ASSGN_VW
AUC_TSK_EVENT_IDAUC_PLN_EVT_VW(SQL View) |
Index Back |
|---|---|
Plan Event Summary ViewPlan Event Summary View |
| SELECT DISTINCT A.BUSINESS_UNIT , A.AUC_PLAN_ID , A.AUC_VERSION , A.AUC_TSK_BUS_UNIT , A.AUC_TSK_EVENT_ID , B.AUC_VERSION , A.AUC_TSK_BUS_UNIT %Concat '-' %Concat A.AUC_TSK_EVENT_ID FROM PS_AUC_TASK_REQ A , PS_AUC_HDR B WHERE A.AUC_REQ_TYPE = 'E' AND B.BUSINESS_UNIT = A.AUC_TSK_BUS_UNIT AND B.AUC_ID = A.AUC_TSK_EVENT_ID AND B.AUC_VERSION = ( SELECT MAX(C.AUC_VERSION) FROM PS_AUC_HDR C WHERE C.BUSINESS_UNIT = A.AUC_TSK_BUS_UNIT AND C.AUC_ID = A.AUC_TSK_EVENT_ID ) |
| # | 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_TSK_BUS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Task requirement Business Unit
Prompt Table: AUC_BU_ASSGN_VW |
| 5 | AUC_TSK_EVENT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Task requirement event ID |
| 6 | AUC_TSK_VERSION | Number(5,0) | INTEGER NOT NULL | Event Version |
| 7 | AUC_ID_BUS_UNIT | Character(18) | VARCHAR2(18) NOT NULL | Bus Unit-Auction ID |