APPS.WSMPLBMI dependencies on WSM_OP_SECONDARY_QUANTITIES

Line 9172: update wsm_op_secondary_quantities

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

Line 9574: UPDATE WSM_OP_SECONDARY_QUANTITIES

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

Line 9636: update wsm_op_secondary_quantities

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

Line 9646: FROM WSM_OP_SECONDARY_QUANTITIES WOSC

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

Line 12316: FROM WSM_OP_SECONDARY_QUANTITIES

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

Line 12831: FROM WSM_OP_SECONDARY_QUANTITIES

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