APPS.CSTPLVCP dependencies on MTL_CST_LAYER_ACT_COST_DETAILS

Line 1640: from mtl_cst_layer_act_cost_details

1636:
1637: else
1638: l_stmt_num := 115;
1639: select count(*) into l_mclacd_exists
1640: from mtl_cst_layer_act_cost_details
1641: where transaction_id = i_txn_id
1642: and organization_id = i_org_id
1643: and layer_id = l_from_layer;
1644:

Line 1659: from mtl_cst_layer_act_cost_details mclacd

1655: l_stmt_num := 130;
1656:
1657: select NVL(abs(sum(mclacd.actual_cost * mclacd.layer_quantity) / abs(o_txn_qty)),0)
1658: into l_snd_txn_cost
1659: from mtl_cst_layer_act_cost_details mclacd
1660: where transaction_id = i_txn_id
1661: and organization_id = i_org_id
1662: and layer_id = l_from_layer;
1663:

Line 2581: from mtl_cst_layer_act_cost_details mclacd

2577: NVL((sum(mclacd.actual_cost * abs(mclacd.layer_quantity)) / abs(i_snd_qty)),0)*i_conv_rate/i_um_rate, -- modified for bug #3835412
2578: 0,
2579: 0,
2580: 0
2581: from mtl_cst_layer_act_cost_details mclacd
2582: where organization_id = i_org_id
2583: and transaction_id = i_txn_id
2584: group by cost_element_id,level_type;
2585:

Line 3476: update mtl_cst_layer_act_cost_details mclacd

3472:
3473: l_stmt_num := 92;
3474:
3475: if (l_txn_type_id = 68) and (i_hook <> 1) and (l_layer_chg = 1) then
3476: update mtl_cst_layer_act_cost_details mclacd
3477: set actual_cost = layer_cost
3478: where mclacd.transaction_id = i_txn_id
3479: and mclacd.organization_id = i_org_id
3480: and mclacd.layer_id = l_from_layer;

Line 4038: from mtl_cst_layer_act_cost_details mclacd

4034: mclacd.inventory_item_id,
4035: mclacd.actual_cost,
4036: mclacd.layer_id,
4037: mclacd.layer_quantity
4038: from mtl_cst_layer_act_cost_details mclacd
4039: where mclacd.transaction_id = c_transaction_id
4040: and mclacd.layer_id = i_from_layer;
4041:
4042: type t_cst_element is table of number

Line 4144: from mtl_cst_layer_act_cost_details mcacd

4140: end if;
4141:
4142: select count(*)
4143: into l_count
4144: from mtl_cst_layer_act_cost_details mcacd
4145: where mcacd.level_type = l_level_type
4146: and mcacd.cost_element_id = decode(mod(l_index_counter,5),0,5,mod(l_index_counter,5))
4147: and mcacd.transaction_id = i_txn_id
4148: and mcacd.layer_id = i_from_layer;

Line 4160: update mtl_cst_layer_act_cost_details mcacd

4156:
4157: --variance to be updated in mclacd
4158: mclacd_variance := l_variance * abs(i_txn_qty) / l_count;
4159:
4160: update mtl_cst_layer_act_cost_details mcacd
4161: set mcacd.payback_variance_amount = mclacd_variance
4162: where mcacd.transaction_id = i_txn_id
4163: and mcacd.cost_element_id = decode(mod(l_index_counter,5),0,5,mod(l_index_counter,5))
4164: and mcacd.level_type = l_level_type