PL_WBEN_ITEM_VW(SQL View) |
Index Back |
---|---|
View contains group code, confRAG# 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 |