SF_PRDN_ED1_VW5(SQL View) |
Index Back |
---|---|
SF Production End Date View |
SELECT DISTINCT a.business_unit , a.prdn_area_code , a.inv_item_id , a.production_type , a.prdn_due_date , a.prdn_start_date , a.new_prdn_qty , a.expected_prdn_qty , a.prod_status , a.completed_qty , a.production_id FROM ps_sf_prdnid_headr a , ps_sf_variances b WHERE a.ma_prdn_id_flg = 'N' AND a.business_unit = b.business_unit AND a.production_id = b.production_id AND (EXISTS ( SELECT 'x' FROM ps_sf_vars_detail c WHERE a.business_unit = c.BUSINESS_UNIT AND a.production_id = c.production_id) OR EXISTS ( SELECT 'x' FROM PS_SF_CFGVAR_DET d WHERE a.business_unit = d.BUSINESS_UNIT AND a.production_id = d.PRODUCTION_ID)) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | 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 | PRODUCTION_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production RW=Rework SV=Service TD=Teardown |
5 | PRDN_DUE_DATE | Date(10) | DATE | Prdn Due Date |
6 | PRDN_START_DATE | Date(10) | DATE | Prdn Start Date |
7 | NEW_PRDN_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Production Start Qty |
8 | EXPECTED_PRDN_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Production End Qty |
9 | PROD_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Production Status
10=Entered 15=Firmed 20=Released 30=In Process 40=Pend Cmpl 50=Completed 60=Clsd/Labor 70=Clsd/Acctg 90=Canceled |
10 | COMPLETED_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | Completed Qty |
11 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |