SF_OVHD_COST_VW

(SQL View)
 Index Back

Conversion Ovhd Costs


SELECT A.BUSINESS_UNIT ,A.PRODUCTION_ID ,A.OP_SEQUENCE ,B.OVHD_RATE_CODE ,B.COST_ELEMENT ,SUM(A.CE_TOTAL_HOURS) ,SUM(A.CE_EXTENDED_COST) ,B.OH_RATE_TYPE ,B.OVERHEAD_RATE ,B.OVERHEAD_PERCENT ,A.AOQ ,%Round((%DecMult(%DEcMult(SUM(A.CE_EXTENDED_COST),%DecDiv(B.OVERHEAD_PERCENT,100)),D.CE_PERCENT_LAB) + %DecMult(%DEcMult(SUM(A.CE_TOTAL_HOURS), B.OVERHEAD_RATE) , D.CE_LAB_HR)+ %DecMult(B.OVERHEAD_RATE , D.CE_PER_UNIT)) + (%DecMult(%DEcMult(SUM(A.CE_EXTENDED_COST), %DecDiv(B.OVERHEAD_PERCENT,100)) , D.CE_PERCENT_MACH) + %DecMult(%DEcMult(SUM(A.CE_TOTAL_HOURS), B.OVERHEAD_RATE) , D.CE_MACH_HR)),15) FROM PS_SF_CONV_COST_VW A ,PS_CE_FRZCON_OH B ,PS_SF_OP_LIST C ,PS_CE_OH_CONV D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.PRODUCTION_ID = C.PRODUCTION_ID AND A.OP_SEQUENCE = C.OP_SEQUENCE AND ( C.CON_OH_CODE_1 = B.OVHD_RATE_CODE OR C.CON_OH_CODE_2 = B.OVHD_RATE_CODE OR C.CON_OH_CODE_3 = B.OVHD_RATE_CODE OR C.CON_OH_CODE_4 = B.OVHD_RATE_CODE) AND D.CE_SOURCE = 'OH' AND B.OH_RATE_TYPE = D.OH_RATE_TYPE AND ((B.OH_RATE_TYPE IN ('%L', 'PL', 'PU') AND A.TIME_TYPE IN ('1100','1200','1300','1400')) OR (B.OH_RATE_TYPE IN ('%M','PM') AND A.TIME_TYPE IN ('1500','1600','1700','1800'))) GROUP BY A.BUSINESS_UNIT ,A.PRODUCTION_ID ,B.COST_ELEMENT ,B.OH_RATE_TYPE ,B.OVERHEAD_RATE ,B.OVERHEAD_PERCENT ,A.OP_SEQUENCE ,B.OVHD_RATE_CODE ,D.CE_PERCENT_LAB ,D.CE_LAB_HR, A.AOQ, D.CE_PER_UNIT,D.CE_PERCENT_MACH ,D.CE_MACH_HR

# 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
3 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
4 OVHD_RATE_CODE Character(4) VARCHAR2(4) NOT NULL Conversion Ovhd Rate Code

Prompt Table: CE_CONOH_CODE

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

Prompt Table: CE_ELEMENT2_VW

6 CE_TOTAL_HOURS Signed Number(33,15) DECIMAL(31,15) NOT NULL Total Hours
7 CE_CONV_COST Signed Number(33,15) DECIMAL(31,15) NOT NULL Conversion Cost
8 OH_RATE_TYPE Character(2) VARCHAR2(2) NOT NULL Conversion Ovhd Rate Type
%L=% of Labor Amt
%M=% of Mach Amt
PL=Amt Per Labor Hr
PM=Amt Per Mach Hr
PU=Per Unit Amt
9 OVERHEAD_RATE Number(11,4) DECIMAL(10,4) NOT NULL Conversion Overhead Rate
10 OVERHEAD_PERCENT Number(5,1) DECIMAL(4,1) NOT NULL Conversion Overhead %
11 AOQ Signed Number(17,4) DECIMAL(15,4) NOT NULL Average Order Qty
12 CE_EXTENDED_COST Signed Number(32,15) DECIMAL(30,15) NOT NULL Extended Cost