APPS.CSTPLENG dependencies on CST_QUANTITY_LAYERS

Line 1717: cst_quantity_layers cql

1713: l_stmt_num := 55;
1714: SELECT COUNT(*)
1715: INTO l_count
1716: FROM cst_inv_layers cil,
1717: cst_quantity_layers cql
1718: WHERE cql.layer_id = i_layer_id
1719: AND cil.inv_layer_id = l_inv_layer_id
1720: AND cil.layer_quantity < 0
1721: AND cil.layer_quantity > cql.layer_quantity;

Line 4531: ** (cst_quantity_layers) **

4527: end if; -- end updating mmt
4528:
4529: /********************************************************************
4530: ** Update layer quantity and layer costs information **
4531: ** (cst_quantity_layers) **
4532: ********************************************************************/
4533: if i_no_update_qty = 0 then
4534: l_stmt_num := 45;
4535: update cst_quantity_layers cql

Line 4535: update cst_quantity_layers cql

4531: ** (cst_quantity_layers) **
4532: ********************************************************************/
4533: if i_no_update_qty = 0 then
4534: l_stmt_num := 45;
4535: update cst_quantity_layers cql
4536: set (last_updated_by,
4537: last_update_date,
4538: last_update_login,
4539: request_id,

Line 4595: from cst_quantity_layers_v v

4591: tl_item_cost,
4592: item_cost,
4593: unburdened_cost,
4594: burden_cost
4595: from cst_quantity_layers_v v
4596: where v.layer_id = i_layer_id)
4597: where cql.layer_id = i_layer_id
4598: and exists
4599: (select 'there is detail cost'