DBA Data[Home] [Help]

APPS.PMI_COST_ANALZ_PACK dependencies on SY_UOMS_MST

Line 273: fm_qty_um_v sy_uoms_mst.um_code%TYPE := ' ';

269: IS
270: /* Declare and Initialize variables */
271: primary_product_v ic_item_mst.item_id%TYPE := 0;
272: fm_qty_v fm_matl_dtl.qty%TYPE := 0;
273: fm_qty_um_v sy_uoms_mst.um_code%TYPE := ' ';
274: pm_qty_v gme_material_details.plan_qty%TYPE := 0;
275: pm_qty_um_v sy_uoms_mst.um_code%TYPE := ' ';
276: pri_prod_um_v sy_uoms_mst.um_code%TYPE := ' ';
277: batch_item_id_v gme_material_details.item_id%TYPE := 0;

Line 275: pm_qty_um_v sy_uoms_mst.um_code%TYPE := ' ';

271: primary_product_v ic_item_mst.item_id%TYPE := 0;
272: fm_qty_v fm_matl_dtl.qty%TYPE := 0;
273: fm_qty_um_v sy_uoms_mst.um_code%TYPE := ' ';
274: pm_qty_v gme_material_details.plan_qty%TYPE := 0;
275: pm_qty_um_v sy_uoms_mst.um_code%TYPE := ' ';
276: pri_prod_um_v sy_uoms_mst.um_code%TYPE := ' ';
277: batch_item_id_v gme_material_details.item_id%TYPE := 0;
278: batch_formulaline_id_v gme_material_details.formulaline_id%TYPE := 0;
279: batch_item_qty_v gme_material_details.actual_qty%TYPE := 0;

Line 276: pri_prod_um_v sy_uoms_mst.um_code%TYPE := ' ';

272: fm_qty_v fm_matl_dtl.qty%TYPE := 0;
273: fm_qty_um_v sy_uoms_mst.um_code%TYPE := ' ';
274: pm_qty_v gme_material_details.plan_qty%TYPE := 0;
275: pm_qty_um_v sy_uoms_mst.um_code%TYPE := ' ';
276: pri_prod_um_v sy_uoms_mst.um_code%TYPE := ' ';
277: batch_item_id_v gme_material_details.item_id%TYPE := 0;
278: batch_formulaline_id_v gme_material_details.formulaline_id%TYPE := 0;
279: batch_item_qty_v gme_material_details.actual_qty%TYPE := 0;
280: scale_factor_v NUMBER := 1; /* Primary Scaling Factor */

Line 484: fm_yield_type_um_v sy_uoms_mst.um_code%TYPE := ' ';

480: k NUMBER := 0;
481: P0 NUMBER := 0; P1 NUMBER := 0; S0 NUMBER := 0; S2 NUMBER := 0;
482:
483: fm_yield_type_v sy_uoms_typ.um_type%TYPE := ' ';
484: fm_yield_type_um_v sy_uoms_mst.um_code%TYPE := ' ';
485: tmp_qty_v NUMBER := 0;
486:
487: /* products are primary items per scaling routine */
488:

Line 797: FROM sy_uoms_typ ut,sy_uoms_mst um, ic_item_mst im

793: INTO prim_um,
794: prim_um_type,
795: prim_std_um,
796: prim_stnd_factor
797: FROM sy_uoms_typ ut,sy_uoms_mst um, ic_item_mst im
798: WHERE im.item_id = item_id_vi
799: AND um.um_code = im.item_um
800: AND um.um_type = ut.um_type ;
801: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 816: FROM sy_uoms_typ ut,sy_uoms_mst um

812: INTO
813: from_um_type,
814: from_stnd_um,
815: from_stnd_factor
816: FROM sy_uoms_typ ut,sy_uoms_mst um
817: WHERE um.um_type = ut.um_type
818: and um.um_code = from_uom_vi ;
819: EXCEPTION WHEN NO_DATA_FOUND THEN
820: -- Invalid from_UOM provided for conversion

Line 834: FROM sy_uoms_typ ut,sy_uoms_mst um

830: INTO
831: to_um_type,
832: to_stnd_um,
833: to_stnd_factor
834: FROM sy_uoms_typ ut,sy_uoms_mst um
835: WHERE um.um_type = ut.um_type
836: and um.um_code = to_uom_vi ;
837: EXCEPTION WHEN NO_DATA_FOUND THEN
838: -- Invalid to_UOM provided for converion