APPS.CSTPLCAS dependencies on CST_WIP_LAYERS

Line 29: l_layer cst_wip_layers%ROWTYPE;

25: l_stmt_num NUMBER := 0;
26:
27: l_sql_stmt VARCHAR2(8000);
28: l_layer_cursor CSTPLMWI.REF_CURSOR_TYPE;
29: l_layer cst_wip_layers%ROWTYPE;
30:
31: l_txn_qty_remaining NUMBER;
32: l_consumed_qty NUMBER;
33: l_lot_size NUMBER := 1;

Line 191: update cst_wip_layers CWL

187: l_txn_qty_remaining );
188: END IF;
189:
190: l_stmt_num := 120;
191: update cst_wip_layers CWL
192: set
193: relieved_matl_scrap_qty = relieved_matl_scrap_qty + l_consumed_qty,
194: temp_relieved_qty = temp_relieved_qty + l_consumed_qty
195: where

Line 225: cst_wip_layers CWL,

221: NVL( WROCD.relieved_matl_scrap_value, 0 ) +
222: sum( CWL.temp_relieved_qty * CWLCD.layer_cost ),
223: sum( CWL.temp_relieved_qty * CWLCD.layer_cost )
224: from
225: cst_wip_layers CWL,
226: cst_wip_layer_cost_details CWLCD
227: where
228: CWL.wip_entity_id = WROCD.wip_entity_id and
229: CWL.operation_seq_num = WROCD.operation_seq_num and

Line 270: cst_wip_layers CWL

266: select
267: NVL( WRO.relieved_matl_scrap_quantity, 0 ) +
268: sum( CWL.temp_relieved_qty )
269: from
270: cst_wip_layers CWL
271: where
272: CWL.wip_entity_id = WRO.wip_entity_id and
273: CWL.operation_seq_num = WRO.operation_seq_num and
274: CWL.inventory_item_id = WRO.inventory_item_id and

Line 714: l_layer cst_wip_layers%ROWTYPE;

710: l_stmt_num NUMBER := 0;
711:
712: l_sql_stmt VARCHAR2(8000);
713: l_layer_cursor CSTPLMWI.REF_CURSOR_TYPE;
714: l_layer cst_wip_layers%ROWTYPE;
715:
716: l_txn_qty_remaining NUMBER;
717: l_consumed_qty NUMBER;
718: l_lot_size NUMBER := 1; /* Added as part of LBM */

Line 882: update cst_wip_layers CWL

878: END IF;
879:
880:
881: l_stmt_num := 110;
882: update cst_wip_layers CWL
883: set
884: relieved_matl_scrap_qty = relieved_matl_scrap_qty + l_consumed_qty,
885: temp_relieved_qty = temp_relieved_qty + l_consumed_qty
886: where

Line 917: cst_wip_layers CWL,

913: NVL( WROCD.relieved_matl_scrap_value, 0 ) +
914: sum( CWL.temp_relieved_qty * CWLCD.layer_cost ),
915: sum( CWL.temp_relieved_qty * CWLCD.layer_cost )
916: from
917: cst_wip_layers CWL,
918: cst_wip_layer_cost_details CWLCD
919: where
920: CWL.wip_entity_id = WROCD.wip_entity_id and
921: CWL.operation_seq_num = WROCD.operation_seq_num and

Line 962: cst_wip_layers CWL

958: select
959: NVL( WRO.relieved_matl_scrap_quantity, 0 ) +
960: sum( CWL.temp_relieved_qty )
961: from
962: cst_wip_layers CWL
963: where
964: CWL.wip_entity_id = WRO.wip_entity_id and
965: CWL.operation_seq_num = WRO.operation_seq_num and
966: CWL.inventory_item_id = WRO.inventory_item_id and