APPS.CSTPPWAC dependencies on CST_PAC_QUANTITY_LAYERS

Line 2953: cst_pac_quantity_layers cpql

2949: )
2950: )
2951: FROM mtl_pac_txn_cost_details mptcd,
2952: cst_pac_item_cost_details cpicd,
2953: cst_pac_quantity_layers cpql
2954: WHERE mptcd.transaction_id = i_txn_id
2955: AND mptcd.pac_period_id = i_pac_period_id
2956: AND mptcd.cost_group_id = i_cost_group_id
2957: AND cpql.cost_layer_id = i_cost_layer_id

Line 3251: * The layer qty can be obtained from cst_pac_quantity_layers

3247: * For a value change periodic update cost transaction,
3248: * update the primary_quantity in mmt to the layer quantity from cpql.
3249: * Prior to this, the quantity at the beginning of the period was being
3250: * used and this caused errors in the distributions.
3251: * The layer qty can be obtained from cst_pac_quantity_layers
3252: */
3253: l_stmt_num := 120;
3254: UPDATE mtl_material_transactions mmt
3255: SET --primary_quantity = l_onhand,

Line 3397: cst_pac_quantity_layers

3393: i_prg_id,
3394: SYSDATE,
3395: i_login_id
3396: FROM
3397: cst_pac_quantity_layers
3398: WHERE quantity_layer_id = i_qty_layer_id);
3399:
3400: --- start of auto log ---
3401: <>

Line 3781: UPDATE CST_PAC_QUANTITY_LAYERS cpql

3777:
3778: l_stmt_num := 60;
3779: /* Update CPQL quantity */
3780: FORALL l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST
3781: UPDATE CST_PAC_QUANTITY_LAYERS cpql
3782: SET (last_updated_by,
3783: last_update_date,
3784: last_update_login,
3785: request_id,

Line 3802: FROM cst_pac_quantity_layers cpql

3798: FROM sys.dual)
3799: WHERE cpql.quantity_layer_id = CSTPPINV.l_qty_layer_id_tbl (l_index)
3800: AND EXISTS
3801: (SELECT 'there is a layer'
3802: FROM cst_pac_quantity_layers cpql
3803: WHERE cpql.quantity_layer_id = CSTPPINV.l_qty_layer_id_tbl (l_index));
3804:
3805: l_stmt_num := 70;
3806: /* Clear All PL/SQL tables */

Line 5667: cst_pac_quantity_layers cpql

5663: i_prog_id,
5664: sysdate
5665: FROM cst_pac_item_costs cpic,
5666: cst_pac_item_cost_details cpicd,
5667: cst_pac_quantity_layers cpql
5668: WHERE cpic.pac_period_id = i_pac_period_id
5669: AND cpic.cost_group_id = i_cost_group_id
5670: AND cpicd.cost_layer_id = cpic.cost_layer_id
5671: AND cpql.cost_layer_id = cpic.cost_layer_id