SF_SRH_COMP_VW(SQL View) |
Index Back |
---|---|
Comp Mtnce: Gen View by PID12/18/98 lee 8.0 enhancement force rank #1785. Sort by PID in descending order. 01/20/1999 rag (CN#PL800-1) Included firmed status 5/28/99 SPL CN# MG800-11.0 Added configuration code to record. 11/20/00 ST (#5619501) - Modified Prdn Area Code prompt table to use SF_PRDN_AREA instead of SF_SRH_COMP_VW2. |
SELECT a.business_unit , a.production_id , a.prod_status , a.prdn_area_code , a.inv_item_id , a.production_type , a.new_start_date , a.new_end_date , a.config_code FROM PS_SF_PRDNID_HEADR a WHERE a.ma_prdn_id_flg = 'Y' AND (a.prod_status = '20' OR a.prod_status = '15' OR a.prod_status = '30') |
# | 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: SP_BUMGOP_NONVW |
2 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL |
Production ID
Prompt Table: SF_SRH_COMP_VW1 |
3 | 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 |
4 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL |
Production Area
Prompt Table: SF_PRDN_AREA |
5 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: SF_SRH_COMP_VW3 |
6 | 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 Default Value: PR |
7 | NEW_START_DATE | Date(10) | DATE | Start Date |
8 | NEW_END_DATE | Date(10) | DATE | Due Date |
9 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL |
Product Configurator
Prompt Table: CP_CONFIG_VW |