DBA Data[Home] [Help]

APPS.CSTPLVCP dependencies on CST_INV_LAYER_COST_DETAILS

Line 478: FROM cst_inv_layer_cost_details CILCD

474: i_req_id,
475: i_prg_appl_id,
476: i_prg_id,
477: SYSDATE
478: FROM cst_inv_layer_cost_details CILCD
479: WHERE CILCD.inv_layer_id = (
480: SELECT MIN(inv_layer_id)
481: FROM cst_inv_layers
482: WHERE layer_id = l_layer_id

Line 3256: from cst_inv_layer_cost_details cilcd

3252: NULL,
3253: 'N',
3254: 0,
3255: 'N'
3256: from cst_inv_layer_cost_details cilcd
3257: where layer_id = l_from_layer
3258: and inv_layer_id = l_inv_layer_id;
3259: end if; --- i checking layer cost and inserting MCACD
3260:

Line 3368: FROM cst_inv_layer_cost_details

3364: No rows should be present. Just a safety check
3365: */
3366:
3367: DELETE
3368: FROM cst_inv_layer_cost_details
3369: WHERE inv_layer_id = l_inv_layer_id;
3370:
3371:
3372: INSERT

Line 3373: INTO cst_inv_layer_cost_details (

3369: WHERE inv_layer_id = l_inv_layer_id;
3370:
3371:
3372: INSERT
3373: INTO cst_inv_layer_cost_details (
3374: layer_id,
3375: inv_layer_id,
3376: level_type,
3377: cost_element_id,

Line 3820: from cst_inv_layer_cost_details cilcd

3816: i_prg_id,
3817: sysdate,
3818: i_item_id,
3819: cilcd.layer_cost
3820: from cst_inv_layer_cost_details cilcd
3821: where layer_id = l_from_layer
3822: and inv_layer_id = l_inv_layer_id;
3823: end if; -- end checking for layer cost
3824: