APPS.OPI_DBI_WMS_STORAGE_UTZ_PKG dependencies on OPI_DBI_REP_UOM_STD_CONV_F

Line 744: -- the standard conversion rates table, OPI_DBI_REP_UOM_STD_CONV_F.

740: -- item weight/volume before a value is specified. So no need to
741: -- worry about missing UOMs and specified values.
742: --
743: -- All possible conversions to the reporting UOMs are stored in
744: -- the standard conversion rates table, OPI_DBI_REP_UOM_STD_CONV_F.
745: -- The extraction program will join twice to this table, once
746: -- for weight conversions and once for volume conversions.
747: -- Since certain rows may not join to the conversion fact for
748: -- one of the measures, use outer joins.

Line 905: opi_dbi_rep_uom_std_conv_f wt_conv,

901: eni_oltp_item_star item_attr
902: WHERE conv_items.organization_id = item_attr.organization_id
903: AND conv_items.inventory_item_id = item_attr.inventory_item_id
904: ) items,
905: opi_dbi_rep_uom_std_conv_f wt_conv,
906: opi_dbi_rep_uom_std_conv_f vol_conv
907: WHERE items.weight_uom_code = wt_conv.from_uom_code (+)
908: AND items.wt_rep_uom_code = wt_conv.rep_uom_code (+)
909: AND items.volume_uom_code = vol_conv.from_uom_code (+)

Line 906: opi_dbi_rep_uom_std_conv_f vol_conv

902: WHERE conv_items.organization_id = item_attr.organization_id
903: AND conv_items.inventory_item_id = item_attr.inventory_item_id
904: ) items,
905: opi_dbi_rep_uom_std_conv_f wt_conv,
906: opi_dbi_rep_uom_std_conv_f vol_conv
907: WHERE items.weight_uom_code = wt_conv.from_uom_code (+)
908: AND items.wt_rep_uom_code = wt_conv.rep_uom_code (+)
909: AND items.volume_uom_code = vol_conv.from_uom_code (+)
910: AND items.vol_rep_uom_code = vol_conv.rep_uom_code (+);

Line 1283: -- the standard conversion rates table, OPI_DBI_REP_UOM_STD_CONV_F.

1279: -- item weight/volume before a value is specified. So no need to
1280: -- worry about missing UOMs and specified values.
1281: --
1282: -- All possible conversions to the reporting UOMs are stored in
1283: -- the standard conversion rates table, OPI_DBI_REP_UOM_STD_CONV_F.
1284: -- The extraction program will join twice to this table, once
1285: -- for weight conversions and once for volume conversions.
1286: -- Since certain rows may not join to the conversion fact for
1287: -- one of the measures, use outer joins.

Line 1453: opi_dbi_rep_uom_std_conv_f wt_conv,

1449: eni_oltp_item_star item_attr
1450: WHERE conv_items.organization_id = item_attr.organization_id
1451: AND conv_items.inventory_item_id = item_attr.inventory_item_id
1452: ) items,
1453: opi_dbi_rep_uom_std_conv_f wt_conv,
1454: opi_dbi_rep_uom_std_conv_f vol_conv
1455: WHERE items.weight_uom_code = wt_conv.from_uom_code (+)
1456: AND items.wt_rep_uom_code = wt_conv.rep_uom_code (+)
1457: AND items.volume_uom_code = vol_conv.from_uom_code (+)

Line 1454: opi_dbi_rep_uom_std_conv_f vol_conv

1450: WHERE conv_items.organization_id = item_attr.organization_id
1451: AND conv_items.inventory_item_id = item_attr.inventory_item_id
1452: ) items,
1453: opi_dbi_rep_uom_std_conv_f wt_conv,
1454: opi_dbi_rep_uom_std_conv_f vol_conv
1455: WHERE items.weight_uom_code = wt_conv.from_uom_code (+)
1456: AND items.wt_rep_uom_code = wt_conv.rep_uom_code (+)
1457: AND items.volume_uom_code = vol_conv.from_uom_code (+)
1458: AND items.vol_rep_uom_code = vol_conv.rep_uom_code (+)