APPS.CSTPCOIC dependencies on CST_UOM_CONV_RATES_TEMP

Line 28: * was added for 11.5.10+ CST_UOM_CONV_RATES_TEMP. */

24: l_no_of_rows NUMBER := 0;
25:
26: /* 11.5.10+ New variables to support UOM conversion */
27: /* This cursor selects from a global temp table that *
28: * was added for 11.5.10+ CST_UOM_CONV_RATES_TEMP. */
29: CURSOR cur_uom_conv IS
30: SELECT item_name
31: FROM cst_uom_conv_rates_temp
32: WHERE uom_conversion_rate IS NULL

Line 31: FROM cst_uom_conv_rates_temp

27: /* This cursor selects from a global temp table that *
28: * was added for 11.5.10+ CST_UOM_CONV_RATES_TEMP. */
29: CURSOR cur_uom_conv IS
30: SELECT item_name
31: FROM cst_uom_conv_rates_temp
32: WHERE uom_conversion_rate IS NULL
33: OR uom_conversion_rate IN (0, -99999);
34: c_missing_uom_conv cur_uom_conv%ROWTYPE; -- cursor variable
35: uom_exception EXCEPTION; -- raised when no UOM conversion defined

Line 81: INSERT INTO CST_UOM_CONV_RATES_TEMP (INVENTORY_ITEM_ID, UOM_CONVERSION_RATE, ITEM_NAME)

77: /* Populate the global temp table with the UOM conversion rates for any items *
78: * where the from UOM <> to UOM *
79: */
80:
81: INSERT INTO CST_UOM_CONV_RATES_TEMP (INVENTORY_ITEM_ID, UOM_CONVERSION_RATE, ITEM_NAME)
82: SELECT src.inventory_item_id,
83: inv_convert.inv_um_convert(src.inventory_item_id, 30, NULL, src.primary_uom_code, dst.primary_uom_code, NULL, NULL),
84: substr(src.concatenated_segments,1,50)
85: FROM mtl_system_items_kfv src, mtl_system_items_b dst, cst_item_costs cic

Line 952: FROM cst_item_costs_interface cici, cst_uom_conv_rates_temp cucr

948: UNBURDENED_COST,
949: BURDEN_COST,
950: LOT_SIZE,
951: uom_conversion_rate
952: FROM cst_item_costs_interface cici, cst_uom_conv_rates_temp cucr
953: WHERE cici.inventory_item_id = cucr.inventory_item_id
954: AND cici.group_id = grp_id)
955: SET PL_MATERIAL = PL_MATERIAL / uom_conversion_rate,
956: PL_MATERIAL_OVERHEAD = PL_MATERIAL_OVERHEAD / uom_conversion_rate,

Line 987: FROM cst_item_cst_dtls_interface cicdi, cst_uom_conv_rates_temp cucr

983: UPDATE (
984: SELECT USAGE_RATE_OR_AMOUNT,
985: ITEM_COST,
986: uom_conversion_rate
987: FROM cst_item_cst_dtls_interface cicdi, cst_uom_conv_rates_temp cucr
988: WHERE cicdi.inventory_item_id = cucr.inventory_item_id
989: AND cicdi.basis_type = 1
990: AND cicdi.group_id = grp_id)
991: SET USAGE_RATE_OR_AMOUNT = USAGE_RATE_OR_AMOUNT / uom_conversion_rate,

Line 1004: FROM cst_item_cst_dtls_interface cicdi, cst_uom_conv_rates_temp cucr

1000: UPDATE (
1001: SELECT BASIS_FACTOR,
1002: ITEM_COST,
1003: uom_conversion_rate
1004: FROM cst_item_cst_dtls_interface cicdi, cst_uom_conv_rates_temp cucr
1005: WHERE cicdi.inventory_item_id = cucr.inventory_item_id
1006: AND cicdi.basis_type <> 1
1007: AND cicdi.group_id = grp_id)
1008: SET BASIS_FACTOR = BASIS_FACTOR / uom_conversion_rate,