APPS.CSTPCOIC dependencies on CST_UOM_CONV_RATES_TEMP

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

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

Line 32: FROM cst_uom_conv_rates_temp

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

Line 81: l_sql_stmnt := 'INSERT INTO CST_UOM_CONV_RATES_TEMP (INVENTORY_ITEM_ID, UOM_CONVERSION_RATE, ITEM_NAME)'||

77: /* 11.5.10+ Copy Cost UOM Conversion *
78: /* Populate the global temp table with the UOM conversion rates for any items *
79: * where the from UOM <> to UOM *
80: */
81: l_sql_stmnt := 'INSERT INTO CST_UOM_CONV_RATES_TEMP (INVENTORY_ITEM_ID, UOM_CONVERSION_RATE, ITEM_NAME)'||
82: ' SELECT src.inventory_item_id,inv_convert.inv_um_convert(src.inventory_item_id, 30, NULL, src.primary_uom_code, dst.primary_uom_code, NULL, NULL),'||
83: ' substr(src.concatenated_segments,1,50) FROM mtl_system_items_kfv src, mtl_system_items_b dst, cst_item_costs cic'||
84: ' WHERE cic.cost_type_id = :from_cst_type_id'||
85: ' AND cic.organization_id = :from_org_id'||

Line 964: FROM cst_item_costs_interface cici, cst_uom_conv_rates_temp cucr

960: UNBURDENED_COST,
961: BURDEN_COST,
962: LOT_SIZE,
963: uom_conversion_rate
964: FROM cst_item_costs_interface cici, cst_uom_conv_rates_temp cucr
965: WHERE cici.inventory_item_id = cucr.inventory_item_id
966: AND cici.group_id = grp_id)
967: SET PL_MATERIAL = PL_MATERIAL / uom_conversion_rate,
968: PL_MATERIAL_OVERHEAD = PL_MATERIAL_OVERHEAD / uom_conversion_rate,

Line 1000: FROM cst_item_cst_dtls_interface cicdi, cst_uom_conv_rates_temp cucr

996: SELECT USAGE_RATE_OR_AMOUNT,
997: ITEM_COST,
998: YIELDED_COST, /*Added for bug 14159528*/
999: uom_conversion_rate
1000: FROM cst_item_cst_dtls_interface cicdi, cst_uom_conv_rates_temp cucr
1001: WHERE cicdi.inventory_item_id = cucr.inventory_item_id
1002: AND cicdi.basis_type = 1
1003: AND cicdi.group_id = grp_id)
1004: SET USAGE_RATE_OR_AMOUNT = USAGE_RATE_OR_AMOUNT / uom_conversion_rate,

Line 1019: FROM cst_item_cst_dtls_interface cicdi, cst_uom_conv_rates_temp cucr

1015: SELECT BASIS_FACTOR,
1016: ITEM_COST,
1017: YIELDED_COST, /*Added for bug 14159528*/
1018: uom_conversion_rate
1019: FROM cst_item_cst_dtls_interface cicdi, cst_uom_conv_rates_temp cucr
1020: WHERE cicdi.inventory_item_id = cucr.inventory_item_id
1021: AND cicdi.basis_type <> 1
1022: AND cicdi.group_id = grp_id)
1023: SET BASIS_FACTOR = BASIS_FACTOR / uom_conversion_rate,