APPS.WSMPLBMI dependencies on WSM_OP_SECONDARY_QUANTITIES

Line 9174: update wsm_op_secondary_quantities

9170: AND (p_sec_uom_code_tbls(l_header_id).count > 0)) THEN
9171:
9172: l_stmt_num := 253.2;
9173: forall i in p_sec_uom_code_tbls(l_header_id).first..p_sec_uom_code_tbls(l_header_id).last
9174: update wsm_op_secondary_quantities
9175: set MOVE_OUT_QUANTITY = p_sec_move_out_qty_tbls(l_header_id)(i),
9176: LAST_UPDATE_DATE = sysdate,
9177: LAST_UPDATED_BY = g_user_id
9178: where wip_entity_id = l_wip_entity_id

Line 9576: UPDATE WSM_OP_SECONDARY_QUANTITIES

9572: IF ((p_sec_uom_code_tbls IS NOT NULL) AND (p_sec_uom_code_tbls.exists(l_header_id))
9573: AND (p_sec_uom_code_tbls(l_header_id).count > 0))
9574: THEN
9575: FORALL i in p_sec_uom_code_tbls(l_header_id).FIRST..p_sec_uom_code_tbls(l_header_id).LAST
9576: UPDATE WSM_OP_SECONDARY_QUANTITIES
9577: SET move_in_quantity = p_sec_move_out_qty_tbls(l_header_id)(i)
9578: WHERE wip_entity_id = l_wip_entity_id
9579: AND operation_seq_num = l_job_to_op_seq_num
9580: AND uom_code = p_sec_uom_code_tbls(l_header_id)(i);

Line 9638: update wsm_op_secondary_quantities

9634: IF (((l_fm_intraoperation_step_type = 1) OR (l_fm_intraoperation_step_type = 3) OR (l_fm_intraoperation_step_type = 5))
9635: AND ((l_to_intraoperation_step_type = 1) OR (l_to_intraoperation_step_type = 2)))
9636: AND (l_undone_txn_source_code = 'move out oa page')
9637: THEN --Move Out
9638: update wsm_op_secondary_quantities
9639: set MOVE_OUT_QUANTITY = NULL,
9640: LAST_UPDATE_DATE = sysdate,
9641: LAST_UPDATED_BY = g_user_id
9642: where wip_entity_id = l_wip_entity_id

Line 9648: FROM WSM_OP_SECONDARY_QUANTITIES WOSC

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
9650: AND WJSQ.wip_entity_id = WOSC.wip_entity_id
9651: AND WOSC.wip_entity_id = l_wip_entity_id
9652: AND WOSC.operation_seq_num = l_job_to_op_seq_num),

Line 12318: FROM WSM_OP_SECONDARY_QUANTITIES

12314: INTO x_show_secondary_quantities
12315: FROM dual
12316: WHERE EXISTS(
12317: SELECT 'secondary quantities exist'
12318: FROM WSM_OP_SECONDARY_QUANTITIES
12319: WHERE wip_entity_id = p_wip_entity_id
12320: AND operation_seq_num = p_operation_seq_num
12321:
12322: );

Line 12833: FROM WSM_OP_SECONDARY_QUANTITIES

12829: INTO x_show_secondary_quantities
12830: FROM dual
12831: WHERE EXISTS(
12832: SELECT 'secondary quantities exist'
12833: FROM WSM_OP_SECONDARY_QUANTITIES
12834: WHERE wip_entity_id = p_wip_entity_id
12835: AND operation_seq_num = p_operation_seq_num
12836:
12837: );