BUSINESS_UNITINV_ITEM_IDCM_BOOKCM_OVERRIDES_VW(SQL View) |
Index Back |
|---|---|
Overridden cost profiles05/03/99 RML Renamed from CM_DIFF_PROF_VW 03/17/99 RML Created for CM800-9.0 - Show all item cost profiles where the profiles are set up differently from the associated cost method group. ----------------------------------------------------------------------------------------- select a.BUSINESS_UNIT, a.INV_ITEM_ID, a.CM_BOOK, a.ITM_DESCR, a.CM_GROUP, a.DESCR, a.CM_PROFILE_ID, d.CM_PROFILE_ID, b.SETID, d.SETID from PS_CM_ITEM_MTH2_VW a, PS_SET_CNTRL_REC b, PS_CM_GRP_SETID_VW c, PS_CM_GROUP_DETAIL d where b.SETCNTRLVALUE = a.BUSINESS_UNIT and b.RECNAME = 'MASTER_ITEM_TBL' and c.SETCNTRLVALUE = b.SETID and c.SETID = d.SETID and a.CM_GROUP = d.CM_GROUP and a.CM_BOOK = d.CM_BOOK and a.CM_PROFILE_ID <> d.CM_PROFILE_ID -------------------------------------------------------------------------------------------------------- |
| select a.BUSINESS_UNIT, a.INV_ITEM_ID, a.CM_BOOK, c.DESCR, c.CM_GROUP, e.DESCR, a.CM_PROFILE_ID, f.CM_PROFILE_ID, c.SETID, e.SETID from PS_CM_ITEM_METHOD a, PS_SET_CNTRL_REC b, PS_MASTER_ITEM_TBL c, PS_CM_GRP_SETID_VW d, PS_CM_GROUP_DEFN e, PS_CM_GROUP_DETAIL f where b.SETCNTRLVALUE = a.BUSINESS_UNIT and b.RECNAME = 'MASTER_ITEM_TBL' and b.SETID = c.SETID and a.INV_ITEM_ID = c.INV_ITEM_ID and d.SETCNTRLVALUE = c.SETID and d.SETID = e.SETID and c.CM_GROUP = e.CM_GROUP and e.SETID = f.SETID and e.CM_GROUP = f.CM_GROUP and a.CM_BOOK = f.CM_BOOK and a.CM_PROFILE_ID <> f.CM_PROFILE_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_BOOK |
Character(10) | VARCHAR2(10) NOT NULL | Cost Book |
| 4 | ITM_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Item Description |
| 5 | CM_GROUP | Character(15) | VARCHAR2(15) NOT NULL | 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | CM_PROFILE_ID2 | Character(10) | VARCHAR2(10) NOT NULL | 03/17/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements - created for use in views |
| 8 | CM_PROFILE_ID3 | Character(10) | VARCHAR2(10) NOT NULL | 03/17/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements - created for use in views |
| 9 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 10 | CM_GROUP_SETID | Character(5) | VARCHAR2(5) NOT NULL | Group SetID |