SF_KIT_RTRN_VW

(SQL View)
 Index Back

Kit Production IDs for De-kit

06/07/99 SPL CN# MG800-11.0 Added configuration code to record.

select a.business_unit, a.production_id, 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 = '30' and a.completed_qty = 0 and a.scrap_qty = 0 and exists (select m.production_id from PS_SF_COMP_LIST m where m.business_unit = a.business_unit and m.production_id = a.production_id and m.issue_method = 'KIT' and (m.issue_qty > 0 or m.yield_qty > 0))

# 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_KIT_PID_VW

3 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area

Prompt Table: SF_SRH_COMP_VW2

4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: SF_SRH_COMP_VW3

5 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
6 NEW_START_DATE Date(10) DATE Start Date
7 NEW_END_DATE Date(10) DATE Due Date
8 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

Prompt Table: CP_CONFIG_VW