DBA Data[Home] [Help]

APPS.GMICUOM dependencies on IC_ITEM_CNV

Line 280: l_cur_uom_factor ic_item_cnv.type_factor%TYPE;

276: l_new_uom_code uomcode_type;
277: l_cur_um_type sy_uoms_typ.um_type%TYPE;
278: l_new_um_type sy_uoms_typ.um_type%TYPE;
279: l_inv_um_type sy_uoms_typ.um_type%TYPE;
280: l_cur_uom_factor ic_item_cnv.type_factor%TYPE;
281: l_cur_conv_factor ic_item_cnv.type_factor%TYPE;
282: l_cur_conv_factorrev ic_item_cnv.type_factor%TYPE; /* Bug 2844068 */
283: l_new_uom_factor ic_item_cnv.type_factor%TYPE;
284: l_new_conv_factor ic_item_cnv.type_factor%TYPE;

Line 281: l_cur_conv_factor ic_item_cnv.type_factor%TYPE;

277: l_cur_um_type sy_uoms_typ.um_type%TYPE;
278: l_new_um_type sy_uoms_typ.um_type%TYPE;
279: l_inv_um_type sy_uoms_typ.um_type%TYPE;
280: l_cur_uom_factor ic_item_cnv.type_factor%TYPE;
281: l_cur_conv_factor ic_item_cnv.type_factor%TYPE;
282: l_cur_conv_factorrev ic_item_cnv.type_factor%TYPE; /* Bug 2844068 */
283: l_new_uom_factor ic_item_cnv.type_factor%TYPE;
284: l_new_conv_factor ic_item_cnv.type_factor%TYPE;
285: l_new_conv_factorrev ic_item_cnv.type_factor%TYPE; /* Bug 2844068 */

Line 282: l_cur_conv_factorrev ic_item_cnv.type_factor%TYPE; /* Bug 2844068 */

278: l_new_um_type sy_uoms_typ.um_type%TYPE;
279: l_inv_um_type sy_uoms_typ.um_type%TYPE;
280: l_cur_uom_factor ic_item_cnv.type_factor%TYPE;
281: l_cur_conv_factor ic_item_cnv.type_factor%TYPE;
282: l_cur_conv_factorrev ic_item_cnv.type_factor%TYPE; /* Bug 2844068 */
283: l_new_uom_factor ic_item_cnv.type_factor%TYPE;
284: l_new_conv_factor ic_item_cnv.type_factor%TYPE;
285: l_new_conv_factorrev ic_item_cnv.type_factor%TYPE; /* Bug 2844068 */
286: l_inv_uom_factor ic_item_cnv.type_factor%TYPE;

Line 283: l_new_uom_factor ic_item_cnv.type_factor%TYPE;

279: l_inv_um_type sy_uoms_typ.um_type%TYPE;
280: l_cur_uom_factor ic_item_cnv.type_factor%TYPE;
281: l_cur_conv_factor ic_item_cnv.type_factor%TYPE;
282: l_cur_conv_factorrev ic_item_cnv.type_factor%TYPE; /* Bug 2844068 */
283: l_new_uom_factor ic_item_cnv.type_factor%TYPE;
284: l_new_conv_factor ic_item_cnv.type_factor%TYPE;
285: l_new_conv_factorrev ic_item_cnv.type_factor%TYPE; /* Bug 2844068 */
286: l_inv_uom_factor ic_item_cnv.type_factor%TYPE;
287: l_lab_conv_factor lm_item_dat.num_data%TYPE;

Line 284: l_new_conv_factor ic_item_cnv.type_factor%TYPE;

280: l_cur_uom_factor ic_item_cnv.type_factor%TYPE;
281: l_cur_conv_factor ic_item_cnv.type_factor%TYPE;
282: l_cur_conv_factorrev ic_item_cnv.type_factor%TYPE; /* Bug 2844068 */
283: l_new_uom_factor ic_item_cnv.type_factor%TYPE;
284: l_new_conv_factor ic_item_cnv.type_factor%TYPE;
285: l_new_conv_factorrev ic_item_cnv.type_factor%TYPE; /* Bug 2844068 */
286: l_inv_uom_factor ic_item_cnv.type_factor%TYPE;
287: l_lab_conv_factor lm_item_dat.num_data%TYPE;
288: l_parm_name lm_item_dat.tech_parm_name%TYPE;

Line 285: l_new_conv_factorrev ic_item_cnv.type_factor%TYPE; /* Bug 2844068 */

281: l_cur_conv_factor ic_item_cnv.type_factor%TYPE;
282: l_cur_conv_factorrev ic_item_cnv.type_factor%TYPE; /* Bug 2844068 */
283: l_new_uom_factor ic_item_cnv.type_factor%TYPE;
284: l_new_conv_factor ic_item_cnv.type_factor%TYPE;
285: l_new_conv_factorrev ic_item_cnv.type_factor%TYPE; /* Bug 2844068 */
286: l_inv_uom_factor ic_item_cnv.type_factor%TYPE;
287: l_lab_conv_factor lm_item_dat.num_data%TYPE;
288: l_parm_name lm_item_dat.tech_parm_name%TYPE;
289: l_factor NUMBER;

Line 286: l_inv_uom_factor ic_item_cnv.type_factor%TYPE;

282: l_cur_conv_factorrev ic_item_cnv.type_factor%TYPE; /* Bug 2844068 */
283: l_new_uom_factor ic_item_cnv.type_factor%TYPE;
284: l_new_conv_factor ic_item_cnv.type_factor%TYPE;
285: l_new_conv_factorrev ic_item_cnv.type_factor%TYPE; /* Bug 2844068 */
286: l_inv_uom_factor ic_item_cnv.type_factor%TYPE;
287: l_lab_conv_factor lm_item_dat.num_data%TYPE;
288: l_parm_name lm_item_dat.tech_parm_name%TYPE;
289: l_factor NUMBER;
290: l_new_qty NUMBER;

Line 330: FROM ic_item_cnv

326: CURSOR get_conversion_factor(v_item_id itm_surg_type,
327: v_lot_id lot_surg_type,
328: v_um_type sy_uoms_typ.um_type%TYPE) IS
329: SELECT type_factor, type_factorrev
330: FROM ic_item_cnv
331: WHERE item_id = v_item_id
332: AND lot_id = v_lot_id
333: AND delete_mark = 0
334: AND um_type = v_um_type;

Line 718: l_cur_uom_factor ic_item_cnv.type_factor%TYPE;

714: l_new_uom_code uomcode_type;
715: l_cur_um_type sy_uoms_typ.um_type%TYPE;
716: l_new_um_type sy_uoms_typ.um_type%TYPE;
717: l_inv_um_type sy_uoms_typ.um_type%TYPE;
718: l_cur_uom_factor ic_item_cnv.type_factor%TYPE;
719: l_cur_conv_factor ic_item_cnv.type_factor%TYPE;
720: l_new_uom_factor ic_item_cnv.type_factor%TYPE;
721: l_new_conv_factor ic_item_cnv.type_factor%TYPE;
722: l_inv_uom_factor ic_item_cnv.type_factor%TYPE;

Line 719: l_cur_conv_factor ic_item_cnv.type_factor%TYPE;

715: l_cur_um_type sy_uoms_typ.um_type%TYPE;
716: l_new_um_type sy_uoms_typ.um_type%TYPE;
717: l_inv_um_type sy_uoms_typ.um_type%TYPE;
718: l_cur_uom_factor ic_item_cnv.type_factor%TYPE;
719: l_cur_conv_factor ic_item_cnv.type_factor%TYPE;
720: l_new_uom_factor ic_item_cnv.type_factor%TYPE;
721: l_new_conv_factor ic_item_cnv.type_factor%TYPE;
722: l_inv_uom_factor ic_item_cnv.type_factor%TYPE;
723: l_lab_conv_factor lm_item_dat.num_data%TYPE;

Line 720: l_new_uom_factor ic_item_cnv.type_factor%TYPE;

716: l_new_um_type sy_uoms_typ.um_type%TYPE;
717: l_inv_um_type sy_uoms_typ.um_type%TYPE;
718: l_cur_uom_factor ic_item_cnv.type_factor%TYPE;
719: l_cur_conv_factor ic_item_cnv.type_factor%TYPE;
720: l_new_uom_factor ic_item_cnv.type_factor%TYPE;
721: l_new_conv_factor ic_item_cnv.type_factor%TYPE;
722: l_inv_uom_factor ic_item_cnv.type_factor%TYPE;
723: l_lab_conv_factor lm_item_dat.num_data%TYPE;
724: l_parm_name lm_item_dat.tech_parm_name%TYPE;

Line 721: l_new_conv_factor ic_item_cnv.type_factor%TYPE;

717: l_inv_um_type sy_uoms_typ.um_type%TYPE;
718: l_cur_uom_factor ic_item_cnv.type_factor%TYPE;
719: l_cur_conv_factor ic_item_cnv.type_factor%TYPE;
720: l_new_uom_factor ic_item_cnv.type_factor%TYPE;
721: l_new_conv_factor ic_item_cnv.type_factor%TYPE;
722: l_inv_uom_factor ic_item_cnv.type_factor%TYPE;
723: l_lab_conv_factor lm_item_dat.num_data%TYPE;
724: l_parm_name lm_item_dat.tech_parm_name%TYPE;
725: l_factor NUMBER;

Line 722: l_inv_uom_factor ic_item_cnv.type_factor%TYPE;

718: l_cur_uom_factor ic_item_cnv.type_factor%TYPE;
719: l_cur_conv_factor ic_item_cnv.type_factor%TYPE;
720: l_new_uom_factor ic_item_cnv.type_factor%TYPE;
721: l_new_conv_factor ic_item_cnv.type_factor%TYPE;
722: l_inv_uom_factor ic_item_cnv.type_factor%TYPE;
723: l_lab_conv_factor lm_item_dat.num_data%TYPE;
724: l_parm_name lm_item_dat.tech_parm_name%TYPE;
725: l_factor NUMBER;
726: l_new_qty NUMBER;

Line 757: FROM ic_item_cnv

753: CURSOR get_conversion_factor(v_item_id itm_surg_type,
754: v_lot_id lot_surg_type,
755: v_um_type sy_uoms_typ.um_type%TYPE) IS
756: SELECT type_factor
757: FROM ic_item_cnv
758: WHERE item_id = v_item_id
759: AND lot_id = v_lot_id
760: AND delete_mark = 0
761: AND um_type = v_um_type;