AUC_PLN_TMPL_VW

(SQL View)
Index Back

Plan Template View

Plan Template View

SELECT BUSINESS_UNIT , AUC_PLAN_ID , AUC_VERSION , AUC_PLAN_NAME FROM PS_AUC_PLAN_HDR WHERE AUC_PLAN_TYPE = 'TE' AND AUC_PLAN_STATUS <> 'IN'

# 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