AUC_PLN_HIST_VW

(SQL View)
Index Back

Most Recent Plans

The most recent versions of all plans

SELECT A.BUSINESS_UNIT , A.AUC_PLAN_ID , A.AUC_PLAN_NAME FROM PS_AUC_PLAN_HDR A WHERE A.AUC_VERSION = ( SELECT MAX(B.AUC_VERSION) FROM PS_AUC_PLAN_HDR B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.AUC_PLAN_ID = A.AUC_PLAN_ID ) AND A.AUC_PLAN_STATUS <> 'CA' AND A.AUC_PLAN_TYPE <> 'TE'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: AUC_BU_ASSGN_VW

2 AUC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Sourcing Planning ID
3 AUC_PLAN_NAME Character(50) VARCHAR2(50) NOT NULL Plan Name