DBA Data[Home] [Help]

APPS.CSTPAVCP dependencies on CST_ITEM_COSTS

Line 4439: Update cst_item_costs cic

4435: group by cost_element_id, level_type;
4436:
4437: l_stmt_num := 40;
4438: /* Used the Base Table instead of View Bug 4773025 */
4439: Update cst_item_costs cic
4440: Set (last_updated_by,
4441: last_update_date,
4442: last_update_login,
4443: request_id,

Line 5189: from cst_item_costs

5185: /* Exception block inserted for bug 1399079, (non costed items) */
5186: BEGIN
5187: select item_cost, -1
5188: into l_snd_txn_cost, l_from_layer_id
5189: from cst_item_costs
5190: where cost_type_id = l_cost_type_id
5191: and inventory_item_id = i_item_id
5192: /* and organization_id = l_from_org; : bugfix 3048258 */
5193: and organization_id = l_std_cost_org;