DBA Data[Home] [Help]

APPS.WSMPLBMI dependencies on WSM_JOB_SECONDARY_QUANTITIES

Line 9182: update wsm_job_secondary_quantities

9178: and uom_code = p_sec_uom_code_tbls(l_header_id)(i);
9179:
9180: l_stmt_num := 253.21;
9181: forall i in p_sec_uom_code_tbls(l_header_id).first..p_sec_uom_code_tbls(l_header_id).last
9182: update wsm_job_secondary_quantities
9183: set CURRENT_QUANTITY = p_sec_move_out_qty_tbls(l_header_id)(i),
9184: LAST_UPDATE_DATE = sysdate,
9185: LAST_UPDATED_BY = g_user_id
9186: where wip_entity_id = l_wip_entity_id

Line 9643: UPDATE WSM_JOB_SECONDARY_QUANTITIES WJSQ

9639: LAST_UPDATED_BY = g_user_id
9640: where wip_entity_id = l_wip_entity_id
9641: and operation_seq_num = l_job_to_op_seq_num;
9642:
9643: UPDATE WSM_JOB_SECONDARY_QUANTITIES WJSQ
9644: SET WJSQ.CURRENT_QUANTITY =
9645: (SELECT MOVE_IN_QUANTITY
9646: FROM WSM_OP_SECONDARY_QUANTITIES WOSC
9647: WHERE WJSQ.UOM_CODE = WOSC.UOM_CODE