BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: CM_BUIN_VW
COST_GROUP_CDPrompt Table: CM_COSTGROUP
CE_COSTGROUP_VW(SQL View) |
Index Back |
|---|---|
Cost Groups by BU |
| SELECT A.BUSINESS_UNIT , D.COST_GROUP_CD , D.DESCR FROM PS_BU_ITEMS_INV A , PS_MASTER_ITEM_TBL B , PS_SET_CNTRL_REC C , PS_CM_COSTGROUP D WHERE B.SETID=C.SETID AND B.SETID=D.SETID AND C.RECNAME='MASTER_ITEM_TBL' AND C.SETCNTRLVALUE=A.BUSINESS_UNIT AND A.INV_ITEM_ID=B.INV_ITEM_ID AND A.COST_GROUP_CD=D.COST_GROUP_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: CM_BUIN_VW |
| 2 | COST_GROUP_CD |
Character(6) | VARCHAR2(6) NOT NULL |
Standard Cost Group
Prompt Table: CM_COSTGROUP |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |