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 739: from wip_requirement_operations WRO,

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

Line 940: from wip_requirement_operations WRO

936: (
937: select wip_entity_id,
938: operation_seq_num,
939: inventory_item_id
940: from wip_requirement_operations WRO
941: where
942: WRO.wip_entity_id = i_wip_entity_id and
943: WRO.operation_seq_num <= i_op_seq_num and
944:

Line 954: update wip_requirement_operations WRO

950:
951:
952:
953: /* update WRO */
954: update wip_requirement_operations WRO
955: set relieved_matl_scrap_quantity
956: =
957: (
958: select