APPS.CSTPLCIR dependencies on CST_WIP_LAYERS

Line 238: cst_wip_layers CWL,

234: select
235: nvl(WROCD.applied_matl_value, 0) + -- add nvl for bug13523172
236: sum( CWL.applied_matl_qty * CWLCD.layer_cost )
237: from
238: cst_wip_layers CWL,
239: cst_wip_layer_cost_details CWLCD
240: where
241: CWL.wip_layer_id = l_wip_layer_id and
242: CWLCD.wip_layer_id = CWL.wip_layer_id and

Line 299: l_layer cst_wip_layers%ROWTYPE;

295: l_stmt_num NUMBER := 0;
296:
297: l_sql_stmt VARCHAR2(8000);
298: l_layer_cursor CSTPLMWI.REF_CURSOR_TYPE;
299: l_layer cst_wip_layers%ROWTYPE;
300:
301: l_txn_qty_remaining NUMBER;
302: l_consumed_qty NUMBER;
303:

Line 389: update cst_wip_layers CWL

385: END IF;
386:
387:
388: l_stmt_num := 80;
389: update cst_wip_layers CWL
390: set
391: applied_matl_qty = applied_matl_qty - l_consumed_qty,
392: temp_relieved_qty = temp_relieved_qty + l_consumed_qty
393: where

Line 445: cst_wip_layers CWL,

441: decode( l_zero_cost_flag, 1, 0, CWLCD.layer_cost ) ),
442: sum( CWL.temp_relieved_qty *
443: decode( l_zero_cost_flag, 1, 0, CWLCD.layer_cost ) )
444: from
445: cst_wip_layers CWL,
446: cst_wip_layer_cost_details CWLCD
447: where
448: CWL.wip_entity_id = WROCD.wip_entity_id and
449: CWL.operation_seq_num = WROCD.operation_seq_num and

Line 503: cst_wip_layers CWL,

499: i_prog_appl_id, -- PROGRAM_APPLICATION_ID,
500: i_prog_id, -- PROGRAM_ID,
501: sysdate -- PROGRAM_UPDATE_DATE
502: from
503: cst_wip_layers CWL,
504: cst_wip_layer_cost_details CWLCD
505: where
506: CWL.wip_entity_id = i_wip_entity_id and
507: CWL.operation_seq_num = i_op_seq_num and