BUSINESS_UNITINV_ITEM_IDCONFIG_CODECP_PRODCOSTH_VW(SQL View) |
Index Back |
|---|---|
CP Production Cost ViewView of CM_PRODCOSTH |
| SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.CONFIG_CODE FROM PS_CM_PRODCOSTH A WHERE A.CONFIG_CODE <> ' ' AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_CM_PRODCOSTH WHERE A.BUSINESS_UNIT = BUSINESS_UNIT AND A.INV_ITEM_ID = INV_ITEM_ID AND A.CONFIG_CODE = CONFIG_CODE) |
| # | 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 | CONFIG_CODE |
Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |