APPS.CSTPLCAS dependencies on WIP_REQUIREMENT_OPERATIONS

Line 52: from wip_requirement_operations WRO

48: quantity_per_assembly)/
49: DECODE(l_include_comp_yield,
50: 1, nvl(component_yield_factor,1),
51: 1) quantity_per_assembly
52: from wip_requirement_operations WRO
53: where WRO.wip_entity_id = i_wip_entity_id and
54: WRO.operation_seq_num <= i_op_seq_num and
55: WRO.wip_supply_type not in (4,5,6) and
56: WRO.quantity_per_assembly <> 0;

Line 248: from wip_requirement_operations WRO

244: (
245: select wip_entity_id,
246: operation_seq_num,
247: inventory_item_id
248: from wip_requirement_operations WRO
249: where
250: WRO.wip_entity_id = i_wip_entity_id and
251: WRO.operation_seq_num <= i_op_seq_num and
252:

Line 262: update wip_requirement_operations WRO

258:
259:
260:
261: /* update WRO */
262: update wip_requirement_operations WRO
263: set relieved_matl_scrap_quantity
264: =
265: (
266: select

Line 741: from wip_requirement_operations WRO,

737: 1) quantity_per_assembly,
738: WRO.relieved_matl_scrap_quantity,
739: decode( nvl( CCS.prior_scrap_quantity, 0 ), 0, 1,
740: i_txn_qty / CCS.prior_scrap_quantity ) component_ratio
741: from wip_requirement_operations WRO,
742: cst_comp_snapshot CCS
743: where WRO.wip_entity_id = i_wip_entity_id and
744: WRO.operation_seq_num <= i_op_seq_num and
745: WRO.wip_supply_type not in (4,5,6) and

Line 943: from wip_requirement_operations WRO

939: (
940: select wip_entity_id,
941: operation_seq_num,
942: inventory_item_id
943: from wip_requirement_operations WRO
944: where
945: WRO.wip_entity_id = i_wip_entity_id and
946: WRO.operation_seq_num <= i_op_seq_num and
947:

Line 957: update wip_requirement_operations WRO

953:
954:
955:
956: /* update WRO */
957: update wip_requirement_operations WRO
958: set relieved_matl_scrap_quantity
959: =
960: (
961: select