APPS.WSMPLBMI dependencies on WIP_REQUIREMENT_OPERATIONS

Line 8799: UPDATE wip_requirement_operations wro

8795: FROM WIP_PARAMETERS
8796: WHERE organization_id = l_organization_id;
8797:
8798: --LBM enh: Modified the expression for quantity_relieved
8799: UPDATE wip_requirement_operations wro
8800: SET QUANTITY_RELIEVED = NVL(wro.QUANTITY_RELIEVED, 0) +
8801: decode(l_converted_scrap_qty,
8802: 0, decode(wro.basis_type, 2, 1, l_txn_qty),
8803: decode(wro.basis_type, 2, 1, l_converted_scrap_qty)) * decode(l_wip_include_comp_yield,

Line 10169: WIP_REQUIREMENT_OPERATIONS WRO

10165: WRO.QUANTITY_RELIEVED,
10166: WRO.COMPONENT_YIELD_FACTOR,
10167: WRO.basis_type
10168: FROM wsm_lot_move_txn_interface WLMTI,
10169: WIP_REQUIREMENT_OPERATIONS WRO
10170: WHERE WLMTI.group_id = p_group_id
10171: AND WLMTI.wip_entity_id = 1439883
10172: AND WLMTI.wip_entity_id = WRO.wip_entity_id
10173: AND WRO.operation_seq_num IN (10, 20)

Line 10225: WIP_REQUIREMENT_OPERATIONS WRO

10221: WRO.QUANTITY_RELIEVED,
10222: WRO.COMPONENT_YIELD_FACTOR,
10223: WRO.basis_type
10224: FROM wsm_lot_move_txn_interface WLMTI,
10225: WIP_REQUIREMENT_OPERATIONS WRO
10226: WHERE WLMTI.group_id = p_group_id
10227: AND WLMTI.wip_entity_id = WRO.wip_entity_id
10228: AND WRO.operation_seq_num IN (WLMTI.FM_OPERATION_SEQ_NUM, WLMTI.TO_OPERATION_SEQ_NUM)
10229: ORDER BY WRO.wip_entity_id,