DBA Data[Home] [Help]

APPS.WSMPOPRN dependencies on WSMPCNST

Line 174: --move enh 115.78 changed from WSMPCNST to WSMPUTIL

170: -- We use program_id of -999 to indicate that the record is
171: -- created by the custom moves form
172:
173: l_stat_num := 10;
174: --move enh 115.78 changed from WSMPCNST to WSMPUTIL
175: IF WSMPUTIL.REFER_SITE_LEVEL_PROFILE = 'Y' THEN
176: l_job_copy_flag := WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE;
177: ELSE
178: l_job_copy_flag := WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE(x_organization_id);

Line 2515: *decode(wcro.basis_type, 2, 1, p_txn_quantity), WSMPCNST.NUMBER_OF_DECIMALS), --LBM enh

2511: decode(nvl(wcro.basis_type,1),1,nvl(wcro1.component_yield_factor,1),1)*wcro.component_yield_factor, --LBM enh
2512: --component shrinkage
2513: -- ROUND((WCRO.quantity_per_assembly/WCRO.component_yield_factor)
2514: ROUND((WCRO.quantity_per_assembly)
2515: *decode(wcro.basis_type, 2, 1, p_txn_quantity), WSMPCNST.NUMBER_OF_DECIMALS), --LBM enh
2516: --component shrinkage
2517: -- WCRO.quantity_per_assembly,
2518: --Bug 5236684:Bill_quantity_per_assembly should include the Bill_quantity_per_assembly of source phantom also.
2519: decode(nvl(wcro.basis_type,1),1,nvl(WCRO1.bill_quantity_per_assembly,1),1)*WCRO.bill_quantity_per_assembly,

Line 3001: *(v_quantity_per_assembly(i)/v_component_yield_factor(i)), WSMPCNST.NUMBER_OF_DECIMALS) --LBM enh

2997: , v_segment20(i)
2998: , v_department_id(i)
2999: --bug 3587239 Round the released quantity to 6 places
3000: , ROUND( decode(v_basis_type(i), 2, 1, p_start_quantity)
3001: *(v_quantity_per_assembly(i)/v_component_yield_factor(i)), WSMPCNST.NUMBER_OF_DECIMALS) --LBM enh
3002: , v_component_yield_factor(i));
3003: END;
3004: ELSE
3005:

Line 3086: 0, 1, WCRO.COMPONENT_YIELD_FACTOR)), WSMPCNST.NUMBER_OF_DECIMALS)*p_txn_quantity,

3082: WCRO.WIP_SUPPLY_TYPE,
3083: decode(recommended, 'Y', Nvl(WCRO.reco_date_required, p_txn_date), p_txn_date),
3084: --move enh 115.77 component yield no longer factored in
3085: /* round((WCRO.quantity_per_assembly/decode(WCRO.COMPONENT_YIELD_FACTOR,
3086: 0, 1, WCRO.COMPONENT_YIELD_FACTOR)), WSMPCNST.NUMBER_OF_DECIMALS)*p_txn_quantity,
3087: */
3088:
3089: /* round((WCRO.quantity_per_assembly/decode(WCRO.COMPONENT_YIELD_FACTOR,
3090: 0, 1, WCRO.COMPONENT_YIELD_FACTOR)), WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),

Line 3097: * decode(wcro.basis_type, 2, 1, p_txn_quantity), WSMPCNST.NUMBER_OF_DECIMALS), --LBM enh

3093: WCRO.basis_type, --LBM enh
3094: -- Component shrinkage
3095: -- ROUND((WCRO.quantity_per_assembly/wcro.component_yield_factor)
3096: ROUND((WCRO.quantity_per_assembly)
3097: * decode(wcro.basis_type, 2, 1, p_txn_quantity), WSMPCNST.NUMBER_OF_DECIMALS), --LBM enh
3098: 0,
3099: --component shrinkage
3100: -- WCRO.quantity_per_assembly,
3101: WCRO.bill_quantity_per_assembly,

Line 3151: *(WCRO.quantity_per_assembly/wcro.component_yield_factor), WSMPCNST.NUMBER_OF_DECIMALS), --LBM enh

3147: NULL,
3148: NULL,
3149: --bug 3587239 Round the released quantity to 6 places
3150: ROUND(decode(wcro.basis_type, 2, 1, p_start_quantity)
3151: *(WCRO.quantity_per_assembly/wcro.component_yield_factor), WSMPCNST.NUMBER_OF_DECIMALS), --LBM enh
3152: WCRO.component_yield_factor --component shrinkage
3153: FROM WSM_COPY_REQUIREMENT_OPS WCRO,
3154: MTL_SYSTEM_ITEMS MSI
3155: WHERE WCRO.OPERATION_SEQ_NUM = p_to_rtg_op_seq_num