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 716: l_layer cst_wip_layers%ROWTYPE;

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

Line 885: update cst_wip_layers CWL

881: END IF;
882:
883:
884: l_stmt_num := 110;
885: update cst_wip_layers CWL
886: set
887: relieved_matl_scrap_qty = relieved_matl_scrap_qty + l_consumed_qty,
888: temp_relieved_qty = temp_relieved_qty + l_consumed_qty
889: where

Line 920: cst_wip_layers CWL,

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

Line 965: cst_wip_layers CWL

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