DBA Data[Home] [Help]

APPS.CSTPLVCP dependencies on CST_INV_LAYER_COST_DETAILS

Line 544: FROM cst_inv_layer_cost_details CILCD

540: i_req_id,
541: i_prg_appl_id,
542: i_prg_id,
543: SYSDATE
544: FROM cst_inv_layer_cost_details CILCD
545: WHERE CILCD.inv_layer_id = (
546: SELECT MIN(inv_layer_id)
547: FROM cst_inv_layers
548: WHERE layer_id = l_layer_id

Line 3322: from cst_inv_layer_cost_details cilcd

3318: NULL,
3319: 'N',
3320: 0,
3321: 'N'
3322: from cst_inv_layer_cost_details cilcd
3323: where layer_id = l_from_layer
3324: and inv_layer_id = l_inv_layer_id;
3325: end if; --- i checking layer cost and inserting MCACD
3326:

Line 3435: FROM cst_inv_layer_cost_details

3431: No rows should be present. Just a safety check
3432: */
3433:
3434: DELETE
3435: FROM cst_inv_layer_cost_details
3436: WHERE inv_layer_id = l_inv_layer_id;
3437:
3438:
3439: INSERT

Line 3440: INTO cst_inv_layer_cost_details (

3436: WHERE inv_layer_id = l_inv_layer_id;
3437:
3438:
3439: INSERT
3440: INTO cst_inv_layer_cost_details (
3441: layer_id,
3442: inv_layer_id,
3443: level_type,
3444: cost_element_id,

Line 3887: from cst_inv_layer_cost_details cilcd

3883: i_prg_id,
3884: sysdate,
3885: i_item_id,
3886: cilcd.layer_cost
3887: from cst_inv_layer_cost_details cilcd
3888: where layer_id = l_from_layer
3889: and inv_layer_id = l_inv_layer_id;
3890: end if; -- end checking for layer cost
3891: