APPS.WSMPLBMI dependencies on WIP_REQUIREMENT_OPERATIONS

Line 8797: UPDATE wip_requirement_operations wro

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

Line 10167: WIP_REQUIREMENT_OPERATIONS WRO

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

Line 10223: WIP_REQUIREMENT_OPERATIONS WRO

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