DBA Data[Home] [Help]

APPS.WSMPLBMI dependencies on WSM_JOB_SECONDARY_QUANTITIES

Line 9184: update wsm_job_secondary_quantities

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

Line 9645: UPDATE WSM_JOB_SECONDARY_QUANTITIES WJSQ

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