APPS.CSTPLCAC dependencies on CST_WIP_LAYERS

Line 34: l_layer cst_wip_layers%ROWTYPE;

30: l_stmt_num NUMBER := 0;
31:
32: l_sql_stmt VARCHAR2(8000);
33: l_layer_cursor CSTPLMWI.REF_CURSOR_TYPE;
34: l_layer cst_wip_layers%ROWTYPE;
35:
36: l_txn_qty_remaining NUMBER;
37: l_consumed_qty NUMBER;
38:

Line 286: update cst_wip_layers CWL

282: -- then call Avg completion algorithm to flush out the values
283: -- from WROCD, WRO, WOO, WOR
284:
285: l_stmt_num := 80;
286: update cst_wip_layers CWL
287: set
288: CWL.relieved_matl_comp_qty =
289: ( CWL.applied_matl_qty -
290: CWL.relieved_matl_scrap_qty -

Line 305: update cst_wip_layers CWL

301: CWL.relieved_matl_scrap_qty -
302: CWL.relieved_matl_final_comp_qty ) >= 0;
303:
304: l_stmt_num := 90;
305: update cst_wip_layers CWL
306: set
307: CWL.relieved_matl_final_comp_qty =
308: ( CWL.applied_matl_qty -
309: CWL.relieved_matl_comp_qty -

Line 531: update cst_wip_layers CWL

527: END IF;
528:
529:
530: l_stmt_num := 160;
531: update cst_wip_layers CWL
532: set
533: relieved_matl_comp_qty = relieved_matl_comp_qty + l_consumed_qty,
534: temp_relieved_qty = temp_relieved_qty + l_consumed_qty
535: where

Line 569: cst_wip_layers CWL,

565: NVL( WROCD.relieved_matl_completion_value, 0 ) +
566: sum( CWL.temp_relieved_qty * CWLCD.layer_cost ),
567: sum( CWL.temp_relieved_qty * CWLCD.layer_cost )
568: from
569: cst_wip_layers CWL,
570: cst_wip_layer_cost_details CWLCD
571: where
572: CWL.wip_entity_id = WROCD.wip_entity_id and
573: CWL.operation_seq_num = WROCD.operation_seq_num and

Line 616: cst_wip_layers CWL

612: select
613: NVL( WRO.relieved_matl_completion_qty, 0 ) +
614: sum( CWL.temp_relieved_qty )
615: from
616: cst_wip_layers CWL
617: where
618: CWL.wip_entity_id = WRO.wip_entity_id and
619: CWL.operation_seq_num = WRO.operation_seq_num and
620: CWL.inventory_item_id = WRO.inventory_item_id and

Line 1146: l_layer cst_wip_layers%ROWTYPE;

1142: l_stmt_num NUMBER := 0;
1143:
1144: l_sql_stmt VARCHAR2(8000);
1145: l_layer_cursor CSTPLMWI.REF_CURSOR_TYPE;
1146: l_layer cst_wip_layers%ROWTYPE;
1147:
1148: l_txn_qty_remaining NUMBER;
1149: l_consumed_qty NUMBER;
1150:

Line 1529: update cst_wip_layers CWL

1525: l_txn_qty_remaining );
1526: END IF;
1527:
1528: l_stmt_num := 90;
1529: update cst_wip_layers CWL
1530: set
1531: relieved_matl_comp_qty = relieved_matl_comp_qty + l_consumed_qty,
1532: temp_relieved_qty = temp_relieved_qty + l_consumed_qty
1533: where

Line 1566: cst_wip_layers CWL,

1562: NVL( WROCD.relieved_matl_completion_value, 0 ) +
1563: sum( CWL.temp_relieved_qty * CWLCD.layer_cost ),
1564: sum( CWL.temp_relieved_qty * CWLCD.layer_cost )
1565: from
1566: cst_wip_layers CWL,
1567: cst_wip_layer_cost_details CWLCD
1568: where
1569: CWL.wip_entity_id = WROCD.wip_entity_id and
1570: CWL.operation_seq_num = WROCD.operation_seq_num and

Line 1613: cst_wip_layers CWL

1609: select
1610: NVL( WRO.relieved_matl_completion_qty, 0 ) +
1611: sum( CWL.temp_relieved_qty )
1612: from
1613: cst_wip_layers CWL
1614: where
1615: CWL.wip_entity_id = WRO.wip_entity_id and
1616: CWL.operation_seq_num = WRO.operation_seq_num and
1617: CWL.inventory_item_id = WRO.inventory_item_id and