AUC_PLN_WKB_VW2

(SQL View)
Index Back

Plan Workbench Result View

Plan Workbench Result View

SELECT A.BUSINESS_UNIT , A.AUC_PLAN_ID , A.AUC_VERSION , A.AUC_PLAN_NAME , A.AUC_PLAN_STATUS , A.PLAN_OWNER , A.CURRENT_OWNER , A.PRIMARY_CATEGORY , A.SECONDARY_CATEGORY , A.START_DATE , A.END_DATE , B.AUC_TSK_BUS_UNIT , B.AUC_TSK_EVENT_ID FROM PS_AUC_PLAN_HDR A , PS_AUC_TASK_REQ B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT(+) AND A.AUC_PLAN_ID = B.AUC_PLAN_ID(+) AND A.AUC_VERSION = B.AUC_VERSION(+) AND A.AUC_PLAN_TYPE = 'PL'

# 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_PLAN_NAME Character(50) VARCHAR2(50) NOT NULL Plan Name
5 AUC_PLAN_STATUS Character(2) VARCHAR2(2) NOT NULL Sourcing Plan Status
AP=Approved
CA=Cancelled
CO=Completed
EX=Executing
IN=Inactive
NE=New
PE=Pending Approval
PO=Posted
6 PLAN_OWNER Character(30) VARCHAR2(30) NOT NULL Plan Owner
7 CURRENT_OWNER Character(30) VARCHAR2(30) NOT NULL Plan Owner
8 PRIMARY_CATEGORY Character(18) VARCHAR2(18) NOT NULL Primary Plan Category
9 SECONDARY_CATEGORY Character(18) VARCHAR2(18) NOT NULL Primary Plan Category
10 START_DATE Date(10) DATE Start Date for Gen Standing PO
11 END_DATE Date(10) DATE End Date
12 AUC_TSK_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Task requirement Business Unit
13 AUC_TSK_EVENT_ID Character(10) VARCHAR2(10) NOT NULL Task requirement event ID