BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
INV_ITEM_IDPRDN_AREA_CODESF_PA_HDR_VW(SQL View) |
Index Back |
|---|---|
Production Areas HDR View11/02/98 SCC CN#EN800-4.0: Add distinct since there are now multiple rows for same item in one area. /* CN# SF750-12.0 ann 10/06/97 -modified the view to search on sf_prdn_area_it instead of sf_prdn_area - so that prdn codes relevant to the items area alone displayed */ |
| select distinct a.business_unit, a.inv_item_id, a.prdn_area_code from PS_SF_PRDN_AREA_IT a |
| # | 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 |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | PRDN_AREA_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Production Area |