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 3256: * The layer qty can be obtained from cst_pac_quantity_layers

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

Line 3402: cst_pac_quantity_layers

3398: i_prg_id,
3399: SYSDATE,
3400: i_login_id
3401: FROM
3402: cst_pac_quantity_layers
3403: WHERE quantity_layer_id = i_qty_layer_id);
3404:
3405: --- start of auto log ---
3406: <>

Line 3812: UPDATE CST_PAC_QUANTITY_LAYERS cpql

3808:
3809: l_stmt_num := 60;
3810: /* Update CPQL quantity */
3811: FORALL l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST
3812: UPDATE CST_PAC_QUANTITY_LAYERS cpql
3813: SET (last_updated_by,
3814: last_update_date,
3815: last_update_login,
3816: request_id,

Line 3833: FROM cst_pac_quantity_layers cpql

3829: FROM sys.dual)
3830: WHERE cpql.quantity_layer_id = CSTPPINV.l_qty_layer_id_tbl (l_index)
3831: AND EXISTS
3832: (SELECT 'there is a layer'
3833: FROM cst_pac_quantity_layers cpql
3834: WHERE cpql.quantity_layer_id = CSTPPINV.l_qty_layer_id_tbl (l_index));
3835:
3836: l_stmt_num := 70;
3837: /* Clear All PL/SQL tables */

Line 5708: cst_pac_quantity_layers cpql

5704: i_prog_id,
5705: sysdate
5706: FROM cst_pac_item_costs cpic,
5707: cst_pac_item_cost_details cpicd,
5708: cst_pac_quantity_layers cpql
5709: WHERE cpic.pac_period_id = i_pac_period_id
5710: AND cpic.cost_group_id = i_cost_group_id
5711: AND cpicd.cost_layer_id = cpic.cost_layer_id
5712: AND cpql.cost_layer_id = cpic.cost_layer_id