DBA Data[Home] [Help]

APPS.OPI_DBI_REP_UOM_STD_CONV_PKG dependencies on OPI_DBI_REP_UOMS

Line 348: FROM opi_dbi_rep_uoms

344: DISTINCT
345: rep_uom_code,
346: rep_uom_class,
347: base_rep_uom_code
348: FROM opi_dbi_rep_uoms
349: WHERE measure_code in ('WT', 'VOL')
350: AND rep_uom_code IS NOT NULL) msr_mst,
351: mtl_units_of_measure convs
352: WHERE msr_mst.rep_uom_class = convs.uom_class;

Line 457: FROM opi_dbi_rep_uoms

453: DISTINCT
454: rep_uom_code,
455: rep_uom_class,
456: base_rep_uom_code
457: FROM opi_dbi_rep_uoms
458: WHERE measure_code in ('WT', 'VOL')
459: AND rep_uom_code IS NOT NULL) msr_mst,
460: opi_dbi_uom_class_std_conv convs
461: WHERE ( convs.from_base_uom_code = msr_mst.base_rep_uom_code