DBA Data[Home] [Help]

APPS.CSTPAVCP dependencies on CST_ITEM_COSTS

Line 4264: Update cst_item_costs cic

4260: group by cost_element_id, level_type;
4261:
4262: l_stmt_num := 40;
4263: /* Used the Base Table instead of View Bug 4773025 */
4264: Update cst_item_costs cic
4265: Set (last_updated_by,
4266: last_update_date,
4267: last_update_login,
4268: request_id,

Line 5014: from cst_item_costs

5010: /* Exception block inserted for bug 1399079, (non costed items) */
5011: BEGIN
5012: select item_cost, -1
5013: into l_snd_txn_cost, l_from_layer_id
5014: from cst_item_costs
5015: where cost_type_id = l_cost_type_id
5016: and inventory_item_id = i_item_id
5017: /* and organization_id = l_from_org; : bugfix 3048258 */
5018: and organization_id = l_std_cost_org;