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 2516: *decode(wcro.basis_type, 2, 1, p_txn_quantity), WSMPCNST.NUMBER_OF_DECIMALS), --LBM enh

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

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

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

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

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

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

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

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

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