PL_WBEN_ITEM_VW

(SQL View)
Index Back

View contains group code, conf

RAG# Added for phoenix work bench inquiries.

SELECT PIA1.BUSINESS_UNIT , PIA1.INV_ITEM_ID , PIA1.PLANNER_CD , PIA1.PLANNED_BY , PIA.CATEGORY_ID , PIA.INV_PROD_FAM_CD FROM PS_MASTER_ITEM_TBL PIA ,PS_PL_ITEM_ATTRIB PIA1 ,PS_SET_CNTRL_REC PIA2 WHERE PIA.INV_ITEM_ID = PIA1.INV_ITEM_ID AND PIA2.RECNAME = 'MASTER_ITEM_TBL' AND PIA2.SETID = PIA.SETID AND PIA2.SETCNTRLVALUE = PIA1.BUSINESS_UNIT AND PIA1.INV_ITEM_ID NOT IN ( SELECT CC.INV_ITEM_ID FROM PS_CP_CONFIG CC WHERE CC.BUSINESS_UNIT = PIA1.BUSINESS_UNIT )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 PLANNER_CD Character(12) VARCHAR2(12) NOT NULL Planner Code
4 PLANNED_BY Character(1) VARCHAR2(1) NOT NULL Planned By
1=Distribution Planning
2=Master Planning
3=Material Planning
4=Not Planned
5 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
6 INV_PROD_FAM_CD Character(10) VARCHAR2(10) NOT NULL Family