BUSINESS_UNITINV_ITEM_IDCM_MFG_ITEMS_VW(SQL View) |
Index Back |
|---|---|
View items available for Mfg02/24/99 RML CM800-9.0 Created view to show all items available for Mfg at business unit level; only items that have all its standard cost type in all its profiles qualify to be available for Mfg. |
| select BUSINESS_UNIT , INV_ITEM_ID , sum(c.CM_MFG_ITEM_FLG) from PS_CM_ITEM_METH_VW a, PS_CM_PROFILE_DEFN b, PS_CM_PROFILES c where a.CM_PROFILE_ID = b.CM_PROFILE_ID and b.CM_TYPE = c.CM_TYPE and b.CM_FLOW = b.CM_FLOW and b.CM_METHOD = c.CM_METHOD group by BUSINESS_UNIT, INV_ITEM_ID |
| # | 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 | CM_MFG_ITEM_FLG | Number(3,0) | SMALLINT NOT NULL | 02/23/99 Created for Release 8 - CM800-9.0 by RML |