APPS.CSTPLCIR dependencies on CST_WIP_LAYERS

Line 232: cst_wip_layers CWL,

228: select
229: WROCD.applied_matl_value +
230: sum( CWL.applied_matl_qty * CWLCD.layer_cost )
231: from
232: cst_wip_layers CWL,
233: cst_wip_layer_cost_details CWLCD
234: where
235: CWL.wip_layer_id = l_wip_layer_id and
236: CWLCD.wip_layer_id = CWL.wip_layer_id and

Line 293: l_layer cst_wip_layers%ROWTYPE;

289: l_stmt_num NUMBER := 0;
290:
291: l_sql_stmt VARCHAR2(8000);
292: l_layer_cursor CSTPLMWI.REF_CURSOR_TYPE;
293: l_layer cst_wip_layers%ROWTYPE;
294:
295: l_txn_qty_remaining NUMBER;
296: l_consumed_qty NUMBER;
297:

Line 383: update cst_wip_layers CWL

379: END IF;
380:
381:
382: l_stmt_num := 80;
383: update cst_wip_layers CWL
384: set
385: applied_matl_qty = applied_matl_qty - l_consumed_qty,
386: temp_relieved_qty = temp_relieved_qty + l_consumed_qty
387: where

Line 439: cst_wip_layers CWL,

435: decode( l_zero_cost_flag, 1, 0, CWLCD.layer_cost ) ),
436: sum( CWL.temp_relieved_qty *
437: decode( l_zero_cost_flag, 1, 0, CWLCD.layer_cost ) )
438: from
439: cst_wip_layers CWL,
440: cst_wip_layer_cost_details CWLCD
441: where
442: CWL.wip_entity_id = WROCD.wip_entity_id and
443: CWL.operation_seq_num = WROCD.operation_seq_num and

Line 497: cst_wip_layers CWL,

493: i_prog_appl_id, -- PROGRAM_APPLICATION_ID,
494: i_prog_id, -- PROGRAM_ID,
495: sysdate -- PROGRAM_UPDATE_DATE
496: from
497: cst_wip_layers CWL,
498: cst_wip_layer_cost_details CWLCD
499: where
500: CWL.wip_entity_id = i_wip_entity_id and
501: CWL.operation_seq_num = i_op_seq_num and