APPS.PMI_COST_ANALZ_PACK dependencies on SY_UOMS_TYP

Line 483: fm_yield_type_v sy_uoms_typ.um_type%TYPE := ' ';

479: numerator NUMBER := 0;
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 */

Line 537: sy_uoms_typ

533:
534: /* now get the std uom of fm_yield_type */
535: SELECT std_um INTO fm_yield_type_um_v
536: FROM
537: sy_uoms_typ
538: WHERE
539: um_type = fm_yield_type_v;
540:
541: /* if there is no fm_yield_type_um then exit scaling with error */

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