DBA Data[Home] [Help]

APPS.WMS_POSTALLOC_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 4011: , mtl_material_transactions_s.NEXTVAL

4007: , transaction_batch_id
4008: , pick_slip_number
4009: , lock_flag ) --bug 9130704
4010: VALUES ( l_transaction_header_id(jj)
4011: , mtl_material_transactions_s.NEXTVAL
4012: , 'N'
4013: , 2
4014: , l_last_update_date(jj)
4015: , l_last_updated_by(jj)

Line 4038: , mtl_material_transactions_s.CURRVAL

4034: , l_task_priority(jj)
4035: , l_container_item_id(jj)
4036: , l_operation_plan_id(jj)
4037: , l_wms_task_status(jj)
4038: , mtl_material_transactions_s.CURRVAL
4039: , l_primary_uom_code(jj)
4040: , l_lot_control_code(jj)
4041: , l_serial_control_code(jj)
4042: , l_serial_allocated_flag(jj)

Line 4761: SELECT mtl_material_transactions_s.NEXTVAL

4757: END IF;
4758: RAISE fnd_api.g_exc_unexpected_error;
4759: END;
4760:
4761: SELECT mtl_material_transactions_s.NEXTVAL
4762: INTO l_new_temp_id
4763: FROM DUAL;
4764:
4765: l_task_new_rec.transaction_temp_id := l_new_temp_id;

Line 4821: SELECT mtl_material_transactions_s.NEXTVAL

4817: , l_child_remaining_qty * l_txn_sec_uom_ratio
4818: )
4819: WHERE transaction_temp_id = l_child_rec.transaction_temp_id;
4820:
4821: SELECT mtl_material_transactions_s.NEXTVAL
4822: INTO l_new_child_temp_id
4823: FROM DUAL;
4824:
4825: SELECT *