SF_SCRAPCMP2_VW (SQL View)	Index Back
Scrap Component Cost View 08/06/97 MPD (CN#CP700-1.4) : Created this additional view to pickup configured items that are non-config costed. Used in funclib_sf.upd_scrap_labor ffo 12/07/97 MPD (CN#MG750-6.0): Changes qty_per to sf_qty_per 06/03/99 lee CN#MG800-4.0 Item Attribute @ BU level mods. 01/04/01 MDS R-APANAT-8Z4DP: Skip floorstock components.

SF_SCRAPCMP2_VW

(SQL View)

Scrap Component Cost View

08/06/97 MPD (CN#CP700-1.4) : Created this additional view to pickup configured items that are non-config costed. Used in funclib_sf.upd_scrap_labor ffo 12/07/97 MPD (CN#MG750-6.0): Changes qty_per to sf_qty_per 06/03/99 lee CN#MG800-4.0 Item Attribute @ BU level mods. 01/04/01 MDS R-APANAT-8Z4DP: Skip floorstock components.

SELECT A.BUSINESS_UNIT , A.PRODUCTION_ID , A.COMPONENT_ID , B.CONFIG_CODE , B.EFFDT , 'COMP' , A.OP_SEQUENCE , A.SF_QTY_PER , A.QTY_CODE , A.YIELD , B.COST_ELEMENT , B.TL_COST , B.LL_COST , C.CFG_COST_OPT FROM PS_SF_COMP_LIST A , PS_CM_PRODCOST B , PS_MASTER_ITEM_TBL C ,PS_BU_ITEMS_INV E WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUSINESS_UNIT=E.BUSINESS_UNIT AND A.COMPONENT_ID=E.INV_ITEM_ID AND A.COMPONENT_ID = B.INV_ITEM_ID AND A.CONFIG_CODE <> ' ' AND B.CONFIG_CODE = ' ' AND A.SOURCE_CODE <> '5' AND (A.NON_OWN_FLAG='N' OR E.CONSIGNED_FLAG = 'Y') AND A.COMPONENT_ID = C.INV_ITEM_ID AND C.CFG_COST_OPT = 'N' AND C.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC D WHERE A.BUSINESS_UNIT = D.SETCNTRLVALUE AND D.RECNAME = 'MASTER_ITEM_TBL')

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

2 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID

3 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.

4 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

5 EFFDT Date(10) DATE Effective Date

6 SCRAP_REC_TYPE Character(4) VARCHAR2(4) NOT NULL Scrap Record Type
COMP=Component
LAB=Labor
OVHD=OVHD

7 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence

8 SF_QTY_PER Number(16,10) DECIMAL(15,10) NOT NULL 07/06/99 SCC CN# SF800-9.0: Added label Quantity

9 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order

10 YIELD Number(8,4) DECIMAL(7,4) NOT NULL Component Yield

11 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element

12 TL_SCRAP_AMT Signed Number(16,4) DECIMAL(14,4) NOT NULL This Level Scrap Amount

13 LL_SCRAP_AMT Signed Number(16,4) DECIMAL(14,4) NOT NULL Lower Level Scrap Amount

14 CFG_COST_OPT Character(1) VARCHAR2(1) NOT NULL Configuration Costing
Y/N Table Edit

#	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_BUMG_NONVW
2	PRODUCTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Production ID
3	COMPONENT_ID	Character(18)	VARCHAR2(18) NOT NULL	04/10/00 (Internet Architecture) SCC: Uppercase label Id.
4	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator
5	EFFDT	Date(10)	DATE	Effective Date
6	SCRAP_REC_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Scrap Record Type COMP=Component LAB=Labor OVHD=OVHD
7	OP_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Operation Sequence
8	SF_QTY_PER	Number(16,10)	DECIMAL(15,10) NOT NULL	07/06/99 SCC CN# SF800-9.0: Added label Quantity
9	QTY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Per ASY=Assembly ORD=Order
10	YIELD	Number(8,4)	DECIMAL(7,4) NOT NULL	Component Yield
11	COST_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Cost Element
12	TL_SCRAP_AMT	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	This Level Scrap Amount
13	LL_SCRAP_AMT	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Lower Level Scrap Amount
14	CFG_COST_OPT	Character(1)	VARCHAR2(1) NOT NULL	Configuration Costing Y/N Table Edit