APPS.CSTPLVCP dependencies on MTL_CST_LAYER_ACT_COST_DETAILS

Line 1706: from mtl_cst_layer_act_cost_details

1702:
1703: else
1704: l_stmt_num := 115;
1705: select count(*) into l_mclacd_exists
1706: from mtl_cst_layer_act_cost_details
1707: where transaction_id = i_txn_id
1708: and organization_id = i_org_id
1709: and layer_id = l_from_layer;
1710:

Line 1725: from mtl_cst_layer_act_cost_details mclacd

1721: l_stmt_num := 130;
1722:
1723: select NVL(abs(sum(mclacd.actual_cost * mclacd.layer_quantity) / abs(o_txn_qty)),0)
1724: into l_snd_txn_cost
1725: from mtl_cst_layer_act_cost_details mclacd
1726: where transaction_id = i_txn_id
1727: and organization_id = i_org_id
1728: and layer_id = l_from_layer;
1729:

Line 2647: from mtl_cst_layer_act_cost_details mclacd

2643: NVL((sum(mclacd.actual_cost * abs(mclacd.layer_quantity)) / abs(i_snd_qty)),0)*i_conv_rate/i_um_rate, -- modified for bug #3835412
2644: 0,
2645: 0,
2646: 0
2647: from mtl_cst_layer_act_cost_details mclacd
2648: where organization_id = i_org_id
2649: and transaction_id = i_txn_id
2650: group by cost_element_id,level_type;
2651:

Line 3543: update mtl_cst_layer_act_cost_details mclacd

3539:
3540: l_stmt_num := 92;
3541:
3542: if (l_txn_type_id = 68) and (i_hook <> 1) and (l_layer_chg = 1) then
3543: update mtl_cst_layer_act_cost_details mclacd
3544: set actual_cost = layer_cost
3545: where mclacd.transaction_id = i_txn_id
3546: and mclacd.organization_id = i_org_id
3547: and mclacd.layer_id = l_from_layer;

Line 4105: from mtl_cst_layer_act_cost_details mclacd

4101: mclacd.inventory_item_id,
4102: mclacd.actual_cost,
4103: mclacd.layer_id,
4104: mclacd.layer_quantity
4105: from mtl_cst_layer_act_cost_details mclacd
4106: where mclacd.transaction_id = c_transaction_id
4107: and mclacd.layer_id = i_from_layer;
4108:
4109: type t_cst_element is table of number

Line 4211: from mtl_cst_layer_act_cost_details mcacd

4207: end if;
4208:
4209: select count(*)
4210: into l_count
4211: from mtl_cst_layer_act_cost_details mcacd
4212: where mcacd.level_type = l_level_type
4213: and mcacd.cost_element_id = decode(mod(l_index_counter,5),0,5,mod(l_index_counter,5))
4214: and mcacd.transaction_id = i_txn_id
4215: and mcacd.layer_id = i_from_layer;

Line 4227: update mtl_cst_layer_act_cost_details mcacd

4223:
4224: --variance to be updated in mclacd
4225: mclacd_variance := l_variance * abs(i_txn_qty) / l_count;
4226:
4227: update mtl_cst_layer_act_cost_details mcacd
4228: set mcacd.payback_variance_amount = mclacd_variance
4229: where mcacd.transaction_id = i_txn_id
4230: and mcacd.cost_element_id = decode(mod(l_index_counter,5),0,5,mod(l_index_counter,5))
4231: and mcacd.level_type = l_level_type