BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
PRDN_AREA_CODEINV_ITEM_IDPRDN_START_DATEPRDN_START_SHIFTCOMPONENT_IDSF_COMP_SEL3_VW(SQL View) |
Index Back |
|---|---|
Comp List Sel Sched View |
| SELECT DISTINCT a.business_unit , a.prdn_area_code , a.inv_item_id , a.prdn_start_date , a.prdn_start_shift , b.component_id , c.descr60 FROM ps_sf_prdnid_headr a , ps_sf_comp_list b , PS_MASTER_ITEM_TBL c , ps_set_cntrl_rec d WHERE a.business_unit = d.setcntrlvalue AND d.recname = 'MASTER_ITEM_TBL' AND c.setid = d.setid AND b.component_id = c.inv_item_id AND a.ma_prdn_id_flg = 'N' AND a.prod_status IN ('15','20','30') AND b.business_unit = a.business_unit AND b.production_id = a.production_id |
| # | 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 | PRDN_AREA_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 3 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 4 | PRDN_START_DATE |
Date(10) | DATE | Prdn Start Date |
| 5 | PRDN_START_SHIFT |
Signed Number(2,0) | DECIMAL(1) NOT NULL | Prdn Start Shift |
| 6 | COMPONENT_ID |
Character(18) | VARCHAR2(18) NOT NULL | 04/10/00 (Internet Architecture) SCC: Uppercase label Id. |
| 7 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |