APPS.PMI_COST_ANALZ_PACK dependencies on IC_ITEM_CNV

Line 849: -- If the types do not match, use ic_item_cnv to convert to primary unit

845: IF from_um_type = to_um_type THEN
846: type_cnv_factor_from := 1 ;
847: type_cnv_factor_to := 1 ;
848: ELSE
849: -- If the types do not match, use ic_item_cnv to convert to primary unit
850:
851: -- (Case 1): if to uom is same as primary unit
852: IF (to_um_type = prim_um_type) THEN
853: BEGIN

Line 856: FROM ic_item_cnv

852: IF (to_um_type = prim_um_type) THEN
853: BEGIN
854: SELECT type_factor
855: INTO type_cnv_factor_from
856: FROM ic_item_cnv
857: WHERE item_id = item_id_vi
858: and lot_id = lot_id_vi
859: and um_type = from_um_type
860: ;

Line 874: FROM ic_item_cnv

870: ELSIF from_um_type = prim_um_type THEN
871: BEGIN
872: SELECT type_factor
873: INTO type_cnv_factor_to
874: FROM ic_item_cnv
875: WHERE item_id = item_id_vi
876: and lot_id = lot_id_vi
877: and um_type = to_um_type
878: ;

Line 893: FROM ic_item_cnv

889: -- then to std uom in the primary um
890: BEGIN
891: SELECT type_factor
892: INTO type_cnv_factor_from
893: FROM ic_item_cnv
894: WHERE item_id = item_id_vi
895: and lot_id = lot_id_vi
896: and um_type = from_um_type
897: ;

Line 901: FROM ic_item_cnv

897: ;
898:
899: SELECT type_factor
900: INTO type_cnv_factor_to
901: FROM ic_item_cnv
902: WHERE item_id = item_id_vi
903: and lot_id = lot_id_vi
904: and um_type = to_um_type
905: ;