APPS.OPI_DBI_WMS_CAPACITY_UTZ_PKG dependencies on OPI_DBI_REP_UOM_STD_CONV_F

Line 603: OPI_DBI_REP_UOM_STD_CONV_F, store -1.

599: staging table, OPI_DBI_WMS_CURR_UTZ_SUB_STG. The capacities
600: should be stored in the reporting units of the measures.
601: If the weight or volume capacity is null, store NULL.
602: If the conversion is not defined in the reporting UOM table,
603: OPI_DBI_REP_UOM_STD_CONV_F, store -1.
604:
605: Note also that one or both of the reporting units for weight
606: and volume can be NULL. That is not an error condition.
607:

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

656: -- The locator weight capacity, volume_capacity, weight_uom_code
657: -- and volume_uom_code are stored in the MTL_ITEM_LOCATIONS table.
658: --
659: -- All possible conversions to the reporting UOMs are stored in
660: -- the standard conversion rates table, OPI_DBI_REP_UOM_STD_CONV_F.
661: -- The extraction program will join twice to this table, once
662: -- for weight capacity conversions and once for volume capacity
663: -- conversions. Since certain rows may not join to the conversion
664: -- fact for one of the measures, use outer joins.

Line 690: -- OPI_DBI_REP_UOM_STD_CONV_F.

686: -- capacities must therefore be flagged with a -1 so that it can be
687: -- reported.
688: -- The above conditions are detectable as the corresponding conversion
689: -- rates will be negative in the standard conversion rates table,
690: -- OPI_DBI_REP_UOM_STD_CONV_F.
691: --
692: -- Missing Reporting UOMs:
693: -- 1. The Weight Reporting UOM can be missing.
694: -- 2. The Volume Reporting UOM can be missing.

Line 819: opi_dbi_rep_uom_std_conv_f wt_conv,

815: OR ( mil.max_cubic_area IS NOT NULL
816: AND mil.volume_uom_code IS NOT NULL)
817: )
818: ) loc,
819: opi_dbi_rep_uom_std_conv_f wt_conv,
820: opi_dbi_rep_uom_std_conv_f vol_conv
821: WHERE loc.weight_uom_code = wt_conv.from_uom_code (+)
822: AND loc.wt_rep_uom_code = wt_conv.rep_uom_code (+)
823: AND loc.volume_uom_code = vol_conv.from_uom_code (+)

Line 820: opi_dbi_rep_uom_std_conv_f vol_conv

816: AND mil.volume_uom_code IS NOT NULL)
817: )
818: ) loc,
819: opi_dbi_rep_uom_std_conv_f wt_conv,
820: opi_dbi_rep_uom_std_conv_f vol_conv
821: WHERE loc.weight_uom_code = wt_conv.from_uom_code (+)
822: AND loc.wt_rep_uom_code = wt_conv.rep_uom_code (+)
823: AND loc.volume_uom_code = vol_conv.from_uom_code (+)
824: AND loc.vol_rep_uom_code = vol_conv.rep_uom_code (+);

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

1153: -- 1 - Organization, Inventory Category, Subinventory
1154: -- 0 - Organization, Inventory Category, Subinventory, Item
1155: --
1156: -- All possible conversions to the reporting UOMs are stored in
1157: -- the standard conversion rates table, OPI_DBI_REP_UOM_STD_CONV_F.
1158: -- The extraction program will join twice to this table, once
1159: -- for weight capacity conversions and once for volume capacity
1160: -- conversions. Since certain rows may not join to the conversion
1161: -- fact for one of the measures, use outer joins.

Line 1365: opi_dbi_rep_uom_std_conv_f wt_conv,

1361: items.inv_category_id,
1362: items.unit_weight,
1363: items.unit_volume
1364: ) onh,
1365: opi_dbi_rep_uom_std_conv_f wt_conv,
1366: opi_dbi_rep_uom_std_conv_f vol_conv
1367: WHERE onh.weight_uom_code = wt_conv.from_uom_code (+)
1368: AND onh.wt_rep_uom_code = wt_conv.rep_uom_code (+)
1369: AND onh.volume_uom_code = vol_conv.from_uom_code (+)

Line 1366: opi_dbi_rep_uom_std_conv_f vol_conv

1362: items.unit_weight,
1363: items.unit_volume
1364: ) onh,
1365: opi_dbi_rep_uom_std_conv_f wt_conv,
1366: opi_dbi_rep_uom_std_conv_f vol_conv
1367: WHERE onh.weight_uom_code = wt_conv.from_uom_code (+)
1368: AND onh.wt_rep_uom_code = wt_conv.rep_uom_code (+)
1369: AND onh.volume_uom_code = vol_conv.from_uom_code (+)
1370: AND onh.vol_rep_uom_code = vol_conv.rep_uom_code (+)